Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Nested If Statement with date ranges
Hi,
What is wrong with my formula? It is giving me a False not the number I need? If the dates are 01/01/2006 to 12/31/15 return 120 01/01/1995 to 12/31/05 return 160 01/01/1900 to 12/31/1994 return 200 Thanks, Marlene Last edited by Marlene Maffe : December 23rd 15 at 05:13 PM |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Nested If Statement with date ranges
Hi Marlene,
Am Wed, 23 Dec 2015 17:02:01 +0000 schrieb Marlene Maffe: If the dates are 01/01/2006 to 12/31/15 return 120 01/01/1995 to 12/31/05 return 160 01/01/1900 to 12/31/1994 return 200 try: =IF(A1<=DATE(1994,12,31),200,IF(A1<=DATE(2005,12,3 1),160,120)) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with a nested IF statement | Excel Programming | |||
NESTED IF STATEMENT USING DATE | New Users to Excel | |||
Nested Ranges? | Excel Programming | |||
Nested If Statement | Excel Discussion (Misc queries) | |||
Nested If statement | Excel Worksheet Functions |