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? |
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 |