One way:

=IF(A3="X",500,IF(A4="X",600, IF(A5="X",700,"No data")))


In article ,
KMAPRO wrote:

OK, maybe that wasn't the best way to ask the question...

I need to create this scenario:
Question: "Lot Size?" Answered by "X" under "Small"(A3) "Medium"(A4) or
"Large"(A5)

If (A3) = "X", then (J2)= 500
If (A4) = "X", then (J2) = 600
If (A5) = "X", then (J2) = 700

Obviously, these function will have to recide in the J2 box. I can get it to
work individually using the "=IF" function, but how can I insert multiple
"=IF" functions into the (J2) box?

I have tried using the "=OR" function, but it doesn't allow a return for
individual amounts (500, 600, 700), it will only read TRUE or FALSE

Any help would be greatly appreciated.