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