lundi 24 avril 2017

I am trying to make a weekly projection using nested if in Excel

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