#### ctjacobs2010

##### Board Regular

- Joined
- Dec 12, 2013

- Messages
- 52

If cell A1 is less than 5 years then 3.69. If A1 is equal to 5 up to anything less than 10 than 5.23. If A1 is equal to 10 and less than 15 than 5.85. If A1 is equal to 15 and anything above that is 6.77

I thought it would work if I did this:

=if(A1<5,3.69, if(A1=5-<10,5.23, if(A1=10-<15,5.58, if(A1=15+,6.77,0)

but this didn’t work and I think it is because 5, 10,and 15 are referring to numbers not years and I need it to reference the year in A1

Any help would be greatly appreciated

Thank You,

Ctjacobs2010