LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
KMAPRO
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
bug - type 1-4531 in any cell - returned Jan-51 workaround is '1-. Paidi Excel Discussion (Misc queries) 6 March 24th 05 09:30 PM
counting Multiple answers in 1 cell + column the6thlee Excel Discussion (Misc queries) 1 February 21st 05 09:19 AM
how do I use multiple nested functions? TeeJay Excel Worksheet Functions 3 February 20th 05 05:09 PM
determine which cell a value is returned from curiousg Excel Discussion (Misc queries) 3 February 9th 05 07:15 PM
# of Functions per cell >> for Harlan Grove SUB-ZERO Excel Worksheet Functions 0 January 24th 05 02:39 PM


All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"