How to roud up close to #.#5 and #.#0

#.#1, #.#2 - #.#0
#.#3, #.#4 = #.#5
#.#6, #.#7 = #.#5
#.#8, #.#9 = #.#0

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

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

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

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

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

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