Hi,

You can use as many if() functions as needed.

For example, =If(B5=C5,"G",If(B5=D5,"R",....,"Y")) and so on.

Hope this helps

Regards,
Emece.-

"GMv1" wrote:

my formula is =IF(B5=C5,"G","Y") I really need to add a third value of "R"
if the logical test exceeds a value beyond what is in the current formula.
Thanks in advance for your assistance!