Thread
:
How to write this formula?
View Single Post
#
5
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
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
Reply With Quote