"dlw" wrote in message
...
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