rounding of numbers in worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Audrey - 15 Jul 2004 20:19 GMT

Help! How do I keep formulas in a worksheet from rounding
up or down. Do I need to do a different formula than =sum
(b2+c2)?

Reply to this Message

Chip Pearson - 15 Jul 2004 20:25 GMT

Audrey,

What leads you to believe that Excel is rounding? You might just
need to increase the number of displayed decimal places.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

> Help! How do I keep formulas in a worksheet from rounding
> up or down. Do I need to do a different formula than =sum
> (b2+c2)?

Reply to this Message

Gordon - 15 Jul 2004 23:09 GMT

> Help! How do I keep formulas in a worksheet from rounding
> up or down. Do I need to do a different formula than =sum
> (b2+c2)?

Excel will only "round" if you use the "Roundup" or "Rounddown" statement.
Change the number of decimal places.

Reply to this Message

Norman Harker - 16 Jul 2004 01:51 GMT

Hi Audrey!

I think that you are confusing rounding with formatting. What is
displayed depends upon the formatting that you have applied, or in the
case of General format, is based upon the column width and font size
used. In all these cases, your formula is being stored in Excel as
calculated.

So rather than change your formula, increase the column width or
select a format you feel is accurate enough for display purposes. But
remember that neither action is changing the stored answer.

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au

Reply to this Message