Adding another condtion to IF

[ztiwef]

Hello,

I have created the following formula:

=IF((AND(AC2="N/A";AQ2<=TODAY()));"Error";"OK")

This is working but I need to add another condition; if AC2 is blank then it should be 'Error', if it is filled then it is OK.

Basically need to combine the following:

=IF(AC2="";"Error";"OK")
=IF((AND(AC2="N/A";AQ2<=TODAY()));"Error";"OK")

Can somebody please help me out?

Thank you,
Steve

 

[ztiwef]

Re: Help needed with adding another condtion to IF

Got it!

=IF(OR(AC2="";AND(AC2="N/A";AQ2<=TODAY()));"Error";"OK")