View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 293
Default 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