Rounding numbers question

[Mark Ashley]

Hi

I was wondering if anyone had a quick solution to the following:

I need to round numbers as below.

1.00 to 1.02 rounds to 1.00
1.03 to 1.07 rounds to 1.05
1.08 to 1.10 rounds to 1.10
etc....

Is there an Excel function or an easy way that I can do this rounding?

Cheers

 

[Norman Harker]

Hi Mark!

Use:

=ROUND(A1/.05,0)*0.5


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi Norman
you probably meant

=ROUND(A1/.05,0)*0.05

 

[Norman Harker]

Hi Frank!

Yup!! Alright when I tested after correcting but forgot to change the
formula in the draft post. Time for bed!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Norman
should be quite late (or should I say early) over there in Australia