T
tiffa
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein \(MVP - VB\)
Make sure you have the Analysis ToolPak Add-In loaded...
=MROUND(A1,0.5)
Rick
=MROUND(A1,0.5)
Rick
M
MartinW
And if you don't want to load the Analysis Tool Pack try this,
=ROUND(A1/0.5,0)*0.5
HTH
Martin
=ROUND(A1/0.5,0)*0.5
HTH
Martin
B
Bernd P
=ROUND(A1*2,0)/2
or
=ROUND(A1/5,1)*5
Regards,
Bernd
or
=ROUND(A1/5,1)*5
Regards,
Bernd
M
MartinW
And the reason for your absurdity would be?
Regards
Martin
Regards
Martin