R
Rose
For examples:
I want 23.20 to be 23.00
and
I want 23.6 to be 24.00
Thanks!
I want 23.20 to be 23.00
and
I want 23.6 to be 24.00
Thanks!
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.
J
JE McGimpsey
One way:
=ROUND(23.2,0)
=ROUND(23.2,0)
G
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
=ROUND(A1,0) entered in B1 and copied to B2
Format to 2 DP
Gord Dibben MS Excel MVP
D
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.
=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.
A
Alan
With the value in A1,
=ROUND(A1,0)
Regards,
Alan.
=ROUND(A1,0)
Regards,
Alan.
J
Jim Thomlinson
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
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
A
art
Rose try to click fx function box maybe you need a Roundown () and a Roundup
(), basic function of excel...
(), basic function of excel...