Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
bug - type 1-4531 in any cell - returned Jan-51 workaround is '1-. | Excel Discussion (Misc queries) | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
how do I use multiple nested functions? | Excel Worksheet Functions | |||
determine which cell a value is returned from | Excel Discussion (Misc queries) | |||
# of Functions per cell >> for Harlan Grove | Excel Worksheet Functions |