View Single Post
  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

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"})