View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann
 
Posts: n/a
Default How to write this formula?

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