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
|