Multiple "IF" functions one one cell returned from different cells
 

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.

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.

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

Greetings from New Zealand
Bill K
"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.

Hi

You do not specify what you would like J2 to display if A3, A4, A5 are
blank.
This formula will return a blank.

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

Hope this helps.

George Gee




*KMAPRO* has posted this 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.

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.