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
|