I wasn't sure if anything under 1 yr would be 0 so modify the original
formula slightly.
=IF(A1<1,0,IF(A1<=5,I1,IF(A1<=15,I2,IF(A115,I3,0) )))
The zero at the end is if none of these conditions are met. Broken out
it is:
IF(A1<0 then return 0, if not then
IF(A1<=5 then return value in I1, if not then
IF(A1<=15 then return calue in I2, if not then
IF(A115 then return the value in I3,
if none of the conditions are met then return zero
HTH
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=525373