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

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

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

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

=MROUND(A1,0.5)

Rick


"tiffa" wrote in message
...
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0

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

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

HTH
Martin


"tiffa" wrote in message
...
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0

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

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

Regards,
Bernd

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

And the reason for your absurdity would be?

Regards
Martin

"Bernd P" wrote in message
...
=ROUND(A1*2,0)/2
or
=ROUND(A1/5,1)*5

Regards,
Bernd