That's ok, it's just harder to figure out what you want that way..........it
still could be either Pete's formula, or maybe something like this........

=MAX(2.99,2.99+(A1-5)*0.2)

Vaya con Dios,
Chuck, CABGx3



"stewartlogan" wrote:


sorry to be so vague - the figures were simply plucked from the sky -
thought once i new how to do the function i could work on the figures.


--
stewartlogan
------------------------------------------------------------------------
stewartlogan's Profile: http://www.excelforum.com/member.php...o&userid=31371
View this thread: http://www.excelforum.com/showthread...hreadid=510637