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