How can I round to a 0 or 0.5 in Excel?

[Guest]

For examples:

I want 23.20 to be 23.00
and
I want 23.6 to be 24.00

Thanks!

 

[JE McGimpsey]

One way:

=ROUND(23.2,0)

 

[Gord Dibben]

For your example numbers............assuming in A1 and A2

=ROUND(A1,0) entered in B1 and copied to B2

Format to 2 DP


Gord Dibben MS Excel MVP

 

[David Biddulph]

If you want to round to the nearest whole number
=ROUND(A1,0)

Your subject line talks of rounding to 0 or 0.5, for which one option is
=MROUND(A1,0.5), but you'll need the Analysis ToolPak Add-In for that, or
else you could use =ROUND(A1*2,0)/2.

 

[Alan]

With the value in A1,
=ROUND(A1,0)
Regards,
Alan.

 

[Guest]

Not following you 100% as bot of your examples are rounding up to the nearest
whole number (noting to do with 0.5) ...but here is a formula to round to the
nearest .5

=ROUND(A1/0.5, 0)*0.5

and here it is to round up to the nearest .5

=ROUNDUP(A1/0.5, 0)*0.5

 

[Guest]

Rose try to click fx function box maybe you need a Roundown () and a Roundup
(), basic function of excel...