similar to Ron's but I included result for input less than minimum in
table (ie <500). For what it's worth, I think the op's break points
were incorrect.

=IF(H1<MIN(B1:F1),B2,MIN(HLOOKUP(H1,$B$1:$F$3,2)+( H1-HLOOKUP(H1,$B$1:$F$3,1))*HLOOKUP(H1,$B$1:$F$3,3),O FFSET(A1,1,MATCH(H1,$B$1:$F$1,1)+1)))


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=532916