| 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 |
| 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 | |||
Threaded Mode
