"Dave O" wrote in message
oups.com...
This formula works as well:
=ROUNDDOWN(A1,0)-0.01
... where A1 holds the 2.01 entry.

Yes, providing your margins will allow you to round $2.99 down to $1.99.
--
David Biddulph