i suspect you have too many nested ifs. try doing it with a vlookup
table


2 ""
3 ".52"


etc


--
duane


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