mercredi 17 février 2016

Excel Multiple If statement

Good Day,

Please let me know what is the mistake I made on this formula.

=IF(A6=TRUE,I6,0,IF(B6=TRUE,I6*1.2,I6))

basically what I want to do is, when A6 is true then J6 = I6 and if B6 is also true the value on J6 will be I6*1.2 if not it will remain as J6 = I6 .

Please see screenshot below enter image description here

Aucun commentaire:

Enregistrer un commentaire