It works when I9 is a value but it DOES NOT work when I9=ACTIVE.
Any other suggestions?
"Luke M" wrote:

OR & AND follow similar structure of:
AND(arg1, arg2, arg3, etc)
and returns a single boolean result.

Your formulas:
=IF(OR($A$5-I10<30,I10="ACTIVE"),D10-AG10,D10-E10)

=IF(OR(I10=0,I10$A$5),"NO","YES")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C-town" wrote:

I have never included 'OR' in an if statement.
How will the following statements need to be written excel to get it them
work?

@IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10)

@IF(I10=0#OR#I10=$A$5," NO"," YES")