round up #.#0 and #.#5
How to roud up close to #.#5 and #.#0
#.#1, #.#2 - #.#0 #.#3, #.#4 = #.#5 #.#6, #.#7 = #.#5 #.#8, #.#9 = #.#0 |
round up #.#0 and #.#5
Hi ramzi,
Try: =ROUNDUP(A1/5,2)*5 -- Cheers macropod [MVP - Microsoft Word] "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 |
round up #.#0 and #.#5
hi macropod,
thank you very much :) "macropod" wrote: Hi ramzi, Try: =ROUNDUP(A1/5,2)*5 -- Cheers macropod [MVP - Microsoft Word] "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 |
round up #.#0 and #.#5
hi macropod....
sorry agian...from ur formula the answer will be like below: #.#1, #.#2, #.#3, #.#4 will become #.#5 #.#6, #.#7, #.#8, #.#9 will become #.#0 but i need... #.#1, #.#2, will become #.#0 #.#3, #.#4 will become #.#5 #.#6, #.#7 will become #.#5 #.#8, #.#9 will become #.#0 thank you "macropod" wrote: Hi ramzi, Try: =ROUNDUP(A1/5,2)*5 -- Cheers macropod [MVP - Microsoft Word] "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 |
round up #.#0 and #.#5
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 |
round up #.#0 and #.#5
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 |
All times are GMT +1. The time now is 08:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com