rounding of numbers in worksheet

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

Chip Pearson

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
 
G

Gordon

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.
 
N

Norman Harker

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.
 
Top