if or statement

[bradccollins]

trying to return a value for a sum of time in a set number of days, i have it working so that I can get a yes no answer, and have that conditionally formatted to return green for yes and red for no. What I would like to do is have a third option which I can format orange when the time gets within a certain window before expiring.

This is my formula so-far:

=IF(C3+C4<100,"YES","NO")

So for this I would also like a return of "NEARING" if C3+C4 is greater than 90 but less than 100.

If it has to be done in a macro then I'll forget it, but if it can be done with the formula that would be great!

Thanks in advance.

 

[Robert Mika]

You must decide if your YES will be =100 or other value as you can not have two options
C3+C4<100
C3+C4>90 and C3+C4<100

Look at this:
=IF(AND(C3+C4>=90,C3+C4<100),"NEARING",IF(C3+C4<90,"YES","NO")

In this case YES will be returned when C3+C4<90.

Is taht what you after??

 

[lenze]

Don't make this difficult!!

IF(C3+C4<90,"YES",IF(C3+C4<100,"NEARING","NO"))

lenze