Rounding to a multiple of a decimal

[Jez Elliott]

Hi,

Can anyone help me round to a multiple of a decimal

e.g. to the nearest .0025?

Many thanks,

Jez Elliott

 

[Norman Harker]

Hi Jez!

Try:

=ROUND(A1/0.0025,0)*0.0025

Or
Analysis ToolPak's MROUND

=MROUND(A1,0.0025)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Friday: Belgium (Flemish Community Holiday and
Guldensporenslag); France (La Fete de la Magdalene); International
(World Population Day); Italy (St. Rosalia Day); Mongolia (Revolution
Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Peo Sjoblom]

=ROUND(A1/0.0025,0)*0.0025

where A1 holds the value

 

[Bob Phillips]

Norman,

This hit the NG at 18:26 my time. According to my calculations that is 03:26
in upside down time! Can't sleep!

Regards

Bob

 

[Norman Harker]

Hi Bob!

I knew there was something I had to do!!


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Saturday: Bosnia-Herzegovina (Petrovdan); Canada,
Northern Ireland, and Eire (Orangemen’s Day); Kiribati (Independence
Day); Malaysia (Birthday of the Yang di-Pertua Negi Pulau Pinang);
Micronesia (Micronesian Day); Sao Tome & Principe (Independence Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.