"dlw" <dlw@discussions.microsoft.com> wrote in message
news:58CF2A62-8B24-4914-B8B7-963311CAF631@microsoft.com...
> Getting the 40% markup is easy, right? The rounding is the tricky pary.
Use
> this formula:
>
> =A1+0.05-((A1*10) - INT(A1*10))/10
>
> A1 is the cell with the number you want to round.

But that rounds to 25.05 when the OP was looking for 24.95.

Continuing on dlw's theme, I think you might get the right answer with
=-(-A1+0.05-((-A1*10) - INT(-A1*10))/10)
but I would hope that there might be a more elegant way.
--
David Biddulph