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.
 
You must log in or register to reply here.

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

Excel VBA 1
Rounding down to specific numbers 2
sum totals in excel 4
calculate total hours/minutes from two time cells 7
Returning one of two values in Microsoft Excel 2003 1
ROUNDING NUMBERS 3
rounding up or down 2
dragging formulas acros adjacent cells 3

Back
Top