I have this statement in Excel (Nested IF)
=IF(E3-B3>0,E3-B3,IF(D3-B3>0,(D3-B3),IF(C3-B3>0,C3-B3," ")))
What I am missing is that he 250 value on the last Cell H3 (Dollars to Budget MTD) have to be calculated only (E3-B3)30-50 and returning -20 as a result. However, it is returning 250 which is wrong in my logic.
The 250 value on the last Cell H3 (Dollars to Budget MTD ) have to be calculated only 30 -50 = -20
Aucun commentaire:
Enregistrer un commentaire