formula to show 97.826 as 97.825

K

KevinBoyden

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
 
O

olasa

First, make sure the Analysis ToolPak is installed!
Menu: Tools>Add-Ins...> tick the Analysis ToolPak if it is not alread
ticked.


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

It will round to the nearest 5-multiple.


HTH
Ola Sandströ
 
R

RagDyeR

One way:

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

HTH,

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


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
 
N

N Harkawat

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