| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple conditions and IF Statements
You're welcome - thanks for feeding back.
Pete On Jan 18, 4:55*pm, wrote: On 18 Jan, 11:44, Pete_UK wrote: Try it this way: =IF('Small Business Card Data'!C3-'Small Business Card Data'! B330,"Red",IF('Small Business Card Data'!C3-'Small Business Card Data'!B310,"Yellow","Green")) Hope this helps. Pete On Jan 18, 3:54*pm, wrote: Hello--I am trying to write an IF statement with more than 2 conditions. *Ultimately, I would like to have a formula that calculates the following: IF #1 -- #2 is 10, return "Yellow," Otherwise, return "Green." AND/ OR If #1 -- #2 30, Red, Otherwise return yellow or green (based on thresholds above). *Is this possible? This is what I have so far: =IF('Small Business Card Data'!C3-'Small Business Card Data'! B310,"Yellow","Green") Thanks!- Hide quoted text - - Show quoted text - This is exactly what I was looking for--thanks so much for your help.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif, And Statements - multiple conditions | Excel Worksheet Functions | |||
| Using SUMIF/IF statements for multiple conditions | Excel Worksheet Functions | |||
| Multiple if statements with multiple conditions | Excel Discussion (Misc queries) | |||
| IF statements and conditions | Excel Worksheet Functions | |||
| Sum if statements with conditions | Excel Worksheet Functions | |||
Hybrid Mode
