View Single Post
  #1   Report Post  
Marlene Maffe Marlene Maffe is offline
Junior Member
 
Posts: 1
Default 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 06:13 PM