Hi all, first time poster but long time browser of the site.
Is it possible to use the IF function to return 1 of 3 possible results (Red, Amber or Green)? eg...
IF A1 is greater than 99.00%, B1 should display "Green"
OR
IF A1 is between 95.00% and 98.99%, B1 should display "Amber"
OR
IF A1 is less than 95.00%, B1 should display "Red"
Thanks in advance for any help or advice you can offer
Sean.
Bookmarks