rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Sam said:
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?
Click to expand...

Hi Sam,

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

Ken Johnson
 
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?
Click to expand...

Hi Sam,

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

Ken Johnson
 
Back
Top