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.