Perhaps this may work as well, in J2:
=IF(COUNTA(A3:A5)=0,"",INDEX({500;600;700},MATCH(" X",A3:A5,0)))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"KMAPRO" wrote in message
...
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.