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

For examples:

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

Thanks!

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

One way:

=ROUND(23.2,0)

In article ,
Rose wrote:

For examples:

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

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

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


On Thu, 16 Nov 2006 16:47:01 -0800, Rose wrote:

For examples:

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

Thanks!

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

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.
--
David Biddulph

"Rose" wrote in message
...
For examples:

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

Thanks!

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

With the value in A1,
=ROUND(A1,0)
Regards,
Alan.
"Rose" wrote in message
...
For examples:

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

Thanks!

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

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
--
HTH...

Jim Thomlinson


"Rose" wrote:

For examples:

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

Thanks!

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

Rose try to click fx function box maybe you need a Roundown () and a Roundup
(), basic function of excel...
--
"Simple things amuse simple minds"


"Rose" wrote:

For examples:

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

Thanks!