How to add OR statement

[superkopite]

Hiya guys and gals

Could someone please tell me how to add an OR statement to the
following formula;

=IF(C4<=TODAY()+28,"ILLEGAL","LEGAL")

At the moment if C4 is less than todays date + 28 then write illegal

What i need is to say if C4 is less than todays date + 28 OR E4= yes
then write illegal

I'm sure this is very easy and just a case of me getting my brackets
and commas the wrong way round!!

Cheers

James

 

[Leith Ross]

Hello James,

=IF(OR(C4<=TODAY()+28, E4 = "YES"),"ILLEGAL","LEGAL")

SIncerely,
Leith Ross

 

[bpeltzer]

=IF(OR(C4<=TODAY()+28,E4="yes"),"ILLEGAL","LEGAL")

 

[superkopite]

Thanks a lot Leith it works a treat.

If only i could work out where to put my dashes, commas, brackets
etc!!

Thanks again