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