3 IF statements with condition (if not blank)

[willow1985]

I have the below formula that I am missing something and cannot think of what:

=IF(N2=0,"",IF(S2="0",(N2-I2-(W2*(W2<>""),IF(S2>N2,(N2-S2-(W2*(W2<>""))))

If N2 is 0, leave blank
If S2 is 0: N2-I2 then subtract W2 (only if it is not blank)
If S2 is greater than N2: N2-S2 then subtract W2 (only if it is not blank)

Any help would be appreciated.

Thank you

 

[sandy666]

maybe
IF(S2="0" ===>>> IF(S2=0

 

[CA_Punit]

First Replace S2="0" with S2=0 and try

 

[gaz_chops]

This part "*(W2<>"")" does not work and is not needed, If W is blank then nothing will be minused!

=IF(N2=0,"",IF(S2="0",N2-I2-W2,IF(S2>N2,N2-S2-W2,""))))

 

[CA_Punit]

=IF(N2=0,"",IF(S2="0",(N2-I2)-(W2*(W2<>"")),IF(S2>N2,(N2-S2)-(W2*(W2<>"")))))

or

=IF(N2=0,"",IF(S2=0,(N2-I2)-W2,IF(S2>N2,(N2-S2)-W2)))

 

[DanteAmor]

If S2 is 0: N2-I2 then subtract W2 (only if it is not blank)
If S2 is greater than N2: N2-S2 then subtract W2 (only if it is not blank)

A condition is missing, what if S2 is less than N2?

 

[willow1985]

I used this: =IF(N2=0,"",IF(S2="0",(N2-I2)-(W2*(W2<>"")),IF(S2>N2,(N2-S2)-(W2*(W2<>"")))))

Thanks guys!

 

[gaz_chops]

I am curious as to why you need to check if W2 is not blank! Like I said, if it's blank then it will minus zero!