How to add OR statement
 

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


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=504609

How to add OR statement
 

Hello James,

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

SIncerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=504609

How to add OR statement
 

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

"superkopite" wrote:


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


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=504609

How to add OR statement
 

Thanks a lot Leith it works a treat.

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

Thanks again


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=504609