vendredi 28 octobre 2016

My formula works in one cell but returns FALSE in another cell

I am trying to perform a calculation and the first IF(OR) condition is giving me the right answer, but the second and third IF(OR) conditions are returning "FALSE" instead of a number.

Cell A23 is a dropdown list of products.

Below is my formula. What am I doing wrong?

=IF(OR(A23="ICS OTT",A23="ICS UI"),ROUNDUP(($B$3*$B$5/250*(1+$B$7)),
IF(OR(A23="ICS+VCS UI"),ROUNDUP(($B$3*$B$5/180*(1+$B$7)),
IF(A23="VCS Apps",ROUNDUP(($B$3*$B$6/180*1+$B$7),
"NA"))))))

Aucun commentaire:

Enregistrer un commentaire