| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Nesting IF Statements Based on Same Cell Value
Working on a 'dashboard' ... more like a traffic light, though, I think.
Based on the same cell value {F21) , these statements work fine when written separately: =IF(F21<0.02,"G",0) =IF(AND(F210.02,F21<0.06),"Y",0) =IF(F21=0.06,"R",0) How can I 'hook' them together as one string with one result? |
|
#2
|
|||
|
|||
|
=IF(F21<.02,"G",IF(F21<.06,"Y","R"))
assuming you really meant your 2nd equation to be ...F21=.02, not just . Bob Umlas Excel MVP "Cheryl B." wrote in message ... Working on a 'dashboard' ... more like a traffic light, though, I think. Based on the same cell value {F21) , these statements work fine when written separately: =IF(F21<0.02,"G",0) =IF(AND(F210.02,F21<0.06),"Y",0) =IF(F21=0.06,"R",0) How can I 'hook' them together as one string with one result? |
|
#3
|
|||
|
|||
|
Bob Umlas wrote...
=IF(F21<.02,"G",IF(F21<.06,"Y","R")) assuming you really meant your 2nd equation to be ...F21=.02, not just . .... Or make it a lookup. =LOOKUP(F21,{-1E307;0.02;0.06},{"G";"Y";"R"}) |
|
#4
|
|||
|
|||
|
You may even want to use a conditional format for this. Access conditional
formatting for a cell by selecting the cell and selecting FORMAT - CONDITIONAL FORMATTING. "Cheryl B." wrote: Working on a 'dashboard' ... more like a traffic light, though, I think. Based on the same cell value {F21) , these statements work fine when written separately: =IF(F21<0.02,"G",0) =IF(AND(F210.02,F21<0.06),"Y",0) =IF(F21=0.06,"R",0) How can I 'hook' them together as one string with one result? |
|
#5
|
|||
|
|||
|
EXcellent ...Thanks, Bob!
"Bob Umlas" wrote: =IF(F21<.02,"G",IF(F21<.06,"Y","R")) assuming you really meant your 2nd equation to be ...F21=.02, not just . Bob Umlas Excel MVP "Cheryl B." wrote in message ... Working on a 'dashboard' ... more like a traffic light, though, I think. Based on the same cell value {F21) , these statements work fine when written separately: =IF(F21<0.02,"G",0) =IF(AND(F210.02,F21<0.06),"Y",0) =IF(F21=0.06,"R",0) How can I 'hook' them together as one string with one result? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Linear Mode
