# IF

#### Stylus88

##### New Member
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

##### Active Member
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

Last edited:

#### Stylus88

##### New Member
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!