Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BSA
 
Posts: n/a
Default HOW TO PREVENT NUMBERS IN SPREAD SHEET FROM ROUNDING

IN MY SPREADSHEET THE TOTALS ACROSS THE ROW ARE NOT ADDING CORRECTLY. WHEN
YOU ADD THE CELLS MANUALLY, THERE IS A DIFFERENCE OF 1 PENNY. HOW TO CORRECT
THIS.
  #2   Report Post  
Alan
 
Posts: n/a
Default HOW TO PREVENT NUMBERS IN SPREAD SHEET FROM ROUNDING

Its usually a rounding issue. If your formula is returning 65.0241533 for
example, and you have the cell formatted to two decimal places you will see
65.00, but the odd 0.0241533 is still there and will be summed and totalled
in a formula that adds up the range you have specified. This can make a
significant difference in the total if you were summing say 2000 cells or
more.
The way round it is to use the ROUND function in your formulas (apart from
the final SUM formulas) like this,
=ROUND((Your Formula),2)
This will convert the result of your formula to a true two decimal place
number and should give you a true result in your totals.
Regards,
Alan.
"BSA" wrote in message
...
IN MY SPREADSHEET THE TOTALS ACROSS THE ROW ARE NOT ADDING CORRECTLY.
WHEN
YOU ADD THE CELLS MANUALLY, THERE IS A DIFFERENCE OF 1 PENNY. HOW TO
CORRECT
THIS.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print only selected cell contents without loosing spread sheet for Anna Tozier Excel Discussion (Misc queries) 1 September 16th 05 05:22 PM
How do I sort entire spread sheet. Names w/data rstampa Excel Worksheet Functions 4 September 13th 05 03:10 AM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
how to enter telephone numbers in Excel sheet UMA Excel Discussion (Misc queries) 6 May 6th 05 11:59 PM
how do I make a new spread sheet pop up, based on an entry in a c. jpryce Excel Discussion (Misc queries) 1 April 15th 05 07:57 PM


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"