I know, the formula will only return 51 if A1 is over 1500, if under
1500 say 1125 it would return 38.25, isn't that what you want???

JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495470