lundi 29 mai 2017

multiple if/and statement returning #value! error

I need help with a statement that is returning #value!

I need to my statement to work out if both k4 and i4 are blank then it will return the value in H4. However if only k4 is blank then I want it to show the value of i4 minus h4. This is what I have but it isn't working. Please help.

=IF(AND(K4="",I4=""),H4),IF(K4="",I4-H4)

Aucun commentaire:

Enregistrer un commentaire