rounding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 14 Jan 2007 08:31 GMT

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?

Signature

Sam

Reply to this Message

Ken Johnson - 14 Jan 2007 08:53 GMT

> 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
[quoted text clipped - 4 lines]
> --
> Sam

Hi Sam,

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

Ken Johnson

Reply to this Message

Epinn - 14 Jan 2007 09:31 GMT

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

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
[quoted text clipped - 4 lines]
> --
> Sam

Hi Sam,

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

Ken Johnson

Reply to this Message

Teethless mama - 14 Jan 2007 19:23 GMT

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

> 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?

Reply to this Message

Rate this thread: