formula to show 97.826 as 97.825
 

I have a sheet where i need to show all numbers ending in 0 or 5 so 98.321
would show as 98.320 and 98.324 would show as 98.325 etc... I am obviously
not gr8 at excel so would appreciate som assistance

Cheers Kevin

First, make sure the Analysis ToolPak is installed!
Menu: ToolsAdd-Ins... tick the Analysis ToolPak if it is not already
ticked.


Then use this formula:
=MROUND(A1,5)

It will round to the nearest 5-multiple.


HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=389874

One way:

=ROUND(A1/0.005,0)*0.005
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"KevinBoyden" wrote in message
...
I have a sheet where i need to show all numbers ending in 0 or 5 so 98.321
would show as 98.320 and 98.324 would show as 98.325 etc... I am obviously
not gr8 at excel so would appreciate som assistance

Cheers Kevin

Not thru format. However using this function at each instance where you want
it rounded
=Mround(a1,0.005)


"KevinBoyden" wrote in message
...
I have a sheet where i need to show all numbers ending in 0 or 5 so 98.321
would show as 98.320 and 98.324 would show as 98.325 etc... I am obviously
not gr8 at excel so would appreciate som assistance

Cheers Kevin