rounding

[Guest]

i have set number format to 2 decimal places...but for the final answer i
want the answer to be rounded off to the nearest whole number with 2 d.p
for eg
anwer 312.78 should appear as 313.00..
if i set the format to no dp i get the answer of 313 but the .00 doesnot
appear then. wht am i suppose to do?

 

[Ken Johnson]

i have set number format to 2 decimal places...but for the final answer i
want the answer to be rounded off to the nearest whole number with 2 d.p
for eg
anwer 312.78 should appear as 313.00..
if i set the format to no dp i get the answer of 313 but the .00 doesnot
appear then. wht am i suppose to do?

Hi Sam,

Try using #.00 custom number format and =round(312.78,0)

Ken Johnson

 

[Epinn]

A1: 312.78

=round(A1,0) and =roundup(A1,0) return 313.

A1: 312.14

=round(A1,0) returns 312.
=roundup(A1,0) returns 313.

Format>Cells>Number - 2 decimal places or custom format or use the increase decimal button to display .00

Hope this helps.

Epinn

i have set number format to 2 decimal places...but for the final answer i
want the answer to be rounded off to the nearest whole number with 2 d.p
for eg
anwer 312.78 should appear as 313.00..
if i set the format to no dp i get the answer of 313 but the .00 doesnot
appear then. wht am i suppose to do?

Hi Sam,

Try using #.00 custom number format and =round(312.78,0)

Ken Johnson

 

[Guest]

=CEILING(A1,1)
click on Increase Decimal icon twice