Thread
:
Nesting IF Statements Based on Same Cell Value
View Single Post
#
3
Harlan Grove
Posts: n/a
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"})
Reply With Quote