If Statement
=IF(B4="X","0",IF(C4="X","50",IF(D4="X","125",IF(E 4="X","200","answer
undefined"))))
Are you sure that you want the answers to be text strings? If not, take
away the quotes from round the numbers.
--
David Biddulph
"StephanieH" wrote in message
...
I know I'm making this harder than it realy is, but right now I'm stuck. I
need a formula that will perform the following:
IF B4 = X then display "0"
IF C4 = X then display "50"
IF D4 = X then display "125"
IF E4 = X then display "200"
Any help would be appreciated.
|