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

Sam wrote:
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

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.

FormatCellsNumber - 2 decimal places or custom format or use the increase decimal button to display .00

Hope this helps.

Epinn

"Ken Johnson" wrote in message ups.com...

Sam wrote:
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

Hi Sam,

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

Ken Johnson

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


"Sam" wrote:

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