how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0

[tiffa]

how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0

 

[Rick Rothstein \(MVP - VB\)]

Make sure you have the Analysis ToolPak Add-In loaded...

=MROUND(A1,0.5)

Rick

 

[MartinW]

And if you don't want to load the Analysis Tool Pack try this,
=ROUND(A1/0.5,0)*0.5

HTH
Martin

 

[Bernd P]

=ROUND(A1*2,0)/2
or
=ROUND(A1/5,1)*5

Regards,
Bernd

 

[MartinW]

And the reason for your absurdity would be?

Regards
Martin