rounding of numbers in worksheet

  • Thread starter Thread starter Audrey
  • Start date Start date
A

Audrey

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)?
 
Audrey,

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Audrey said:
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)?
Click to expand...

Excel will only "round" if you use the "Roundup" or "Rounddown" statement.
Change the number of decimal places.
 
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.
 
Back
Top