Thread
:
Rounding up or down in the same formula
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Jack L. Hyman[_2_]
external usenet poster
Posts: 3
Rounding up or down in the same formula
Thank you very much!
"Sandy Mann" wrote:
Are you number always integers? If so try:
=ROUND(A1,-1)-1
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Jack L. Hyman" <Jack L.
wrote in message
...
How do I create a single formula to either round up or down the result of
my
formula to the nearest "9"?
i.e.
843 = 839
845 = 849
etc., etc.
Thanks,
Jack
Reply With Quote
Jack L. Hyman[_2_]
View Public Profile
Find all posts by Jack L. Hyman[_2_]