Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) | |||
What statement to use? | Excel Worksheet Functions |