Thread
:
round up #.#0 and #.#5
View Single Post
#
7
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
round up #.#0 and #.#5
Glad that it helped.
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"ramzi" wrote in message
...
hi Sandy Mann,
Thanks
=ROUND(A2/0.5,1)*0.5
The above formula works for me...
Thank you for sanday and macropod. :)
"Sandy Mann" wrote:
Try:
=ROUND(A1/0.5,0)*0.5
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"ramzi" wrote in message
...
How to roud up close to #.#5 and #.#0
#.#1, #.#2 - #.#0
#.#3, #.#4 = #.#5
#.#6, #.#7 = #.#5
#.#8, #.#9 = #.#0
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann