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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
calculate total hours/minutes from two time cells 7
Organizing a group of notebooks 0
formula for arriving net difference 0
Paragraph numbering in Word 1
Nested if then statement 2
Sum multiple worksheets and summary tab that would sum and count by rep name 0
Rounding down to specific numbers 2

Top