software

Hiya guys and gals

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

=IF(C4lt;=TODAY() 28,quot;ILLEGALquot;,quot;LEGALquot;)

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: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=504609
Hello James,

=IF(OR(C4lt;=TODAY() 28, E4 = quot;YESquot;),quot;ILLEGALquot;,quot;LEGALquot;)

SIncerely,
Leith Ross--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: www.excelforum.com/member.php...oamp;userid=18465
View this thread: www.excelforum.com/showthread...hreadid=504609=IF(OR(C4lt;=TODAY() 28,E4=quot;yesquot;),quot;ILLEGALquot;,quot;LEGALquot;)

quot;superkopitequot; wrote:

gt;
gt; Hiya guys and gals
gt;
gt; Could someone please tell me how to add an OR statement to the
gt; following formula;
gt;
gt; =IF(C4lt;=TODAY() 28,quot;ILLEGALquot;,quot;LEGALquot;)
gt;
gt; At the moment if C4 is less than todays date 28 then write illegal
gt;
gt; What i need is to say if C4 is less than todays date 28 OR E4= yes
gt; then write illegal
gt;
gt; I'm sure this is very easy and just a case of me getting my brackets
gt; and commas the wrong way round!!
gt;
gt; Cheers
gt;
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=504609
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=504609