Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print only selected cell contents without loosing spread sheet for | Excel Discussion (Misc queries) | |||
How do I sort entire spread sheet. Names w/data | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
how to enter telephone numbers in Excel sheet | Excel Discussion (Misc queries) | |||
how do I make a new spread sheet pop up, based on an entry in a c. | Excel Discussion (Misc queries) |