IF

[Stylus88]

I've discovered this thread from a little time, so if it's possible i post another doubt.

I have this formula (really is longer but if a part is correct i suppose that all can be correct as well)

=IF(D15<>0,5 +IF(E15<>0,5 +IF(F15>0,5)))

I wanna have a total that give me a value if any,one,or some of this conditions are confirmed, but in the way that is written it works just if the cell before support the conditions: so it give me 15 If D15 is >0 and E15>5 and F15>5 but it doesn't give me 10 if D15 is 0 and E15>0 and F15>0 or D15>0 E15 is 0 and F15>0

 

[Eric Golf]

Hi,

Separate the Ifs then add them together e.g.

=IF(D15<>0,5,0)+IF(E15<>0,5,0)+IF(F15>0,5,0)

I am sure someone could / will come up with an easier way, such as COUNTIF, but this should get you started.

Hope this helps,

Eric

 

[Dave Patton]

Please review the following to see if one or more of the alternatives addresses your question.

Excel 2010
	B	C	D
2	10	10	10
6c

Cell Formulas
Range	Formula
B2	=IF(D15<>0,5,0)+IF(E15<>0,5,0)+IF(F15>0,5,0)
C2	=COUNTIF(D15:E15,"<>"&0)*5
D2	=(D15<>0)*5+(E15<>0)*5+(F15>0)*5

 

[Stylus88]

Thank you! I realized to have forgotten the brackets in the first formula and now it works! Interesting the second one too, I didn't know it.
So kind as always!