Yes it does - I missed the "round up" part in the OP

--
Thanks for the catch Biff.


Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Biff" wrote in message
...
=ROUND(A1*53%,0)-0.05

That "rounds down" in some cases:

38 * 0.53 = 20.14

ROUND(20.14,0)-0.05 = 19.95

Biff

"Sandy Mann" wrote in message
...
Rory,

Try:

=ROUND(A1*53%,0)-0.05

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Rory" wrote in message
...
* a cell value by 53 % then round up the answer to have .95 on the end.

Thanks
Rory