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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:
 
Perhaps this may work as well, in J2:
=IF(COUNTA(A3:A5)=0,"",INDEX({500;600;700},MATCH("X",A3:A5,0)))
 
Back
Top