Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas do not add up to original value
I have a spreadsheet that works out how much of a set amount should be
divided between different cells. However the figures it works out then do not add up to the original amount that I started with. i.e. it splits 160 into 40.31, 39.45, 36.69 and 43.56 - which addes up to 160.01. How do I stop that!? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas do not add up to original value
You don't give us any formulas, so it is difficult to tell what might be
wrong. Anyway, the addition you give as an example is perfectly OK! Please post values, formulas, expected and acrtual results so we might be able to help -- Kind regards, Niek Otten Microsoft MVP - Excel "Amy6514" wrote in message ... I have a spreadsheet that works out how much of a set amount should be divided between different cells. However the figures it works out then do not add up to the original amount that I started with. i.e. it splits 160 into 40.31, 39.45, 36.69 and 43.56 - which addes up to 160.01. How do I stop that!? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas do not add up to original value
On Oct 18, 2:09*pm, Amy6514 wrote:
I have a spreadsheet that works out how much of a set amount should be divided between different cells. However the figures it works out then do not add up to the original amount that I started with. i.e. it splits 160 into 40.31, 39.45, 36.69 and 43.56 - which addes up to 160.01. How do I stop that!? Rounding happens all the time when one keeps a fixed number of decimal places, and folks tend to live with it. If it's really important that the sum of the rounded parts equals the original amount, then here's one way to do it. Suppose the four parts are formula_1 in A1, formula_2 in A2, formula_3 in A3, formula_4 in A4; with the original amount in B1. First replace formula_1 in A1 by =ROUND(formula_1, 2) Likewise for A2 and A3. Then replace formula_4 in A4 by = ROUND(B1, 2)-A1-A2-A3 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas do not add up to original value
Check out this link...
http://www.mcgimpsey.com/excel/pennyoff.html -- HTH... Jim Thomlinson "Amy6514" wrote: I have a spreadsheet that works out how much of a set amount should be divided between different cells. However the figures it works out then do not add up to the original amount that I started with. i.e. it splits 160 into 40.31, 39.45, 36.69 and 43.56 - which addes up to 160.01. How do I stop that!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying to a new workbook without formulas referencing original wk | Excel Discussion (Misc queries) | |||
Copying formulas between sheets and keeping original ref | Excel Worksheet Functions | |||
How can I copy many formulas and keep original cell location? | Excel Discussion (Misc queries) | |||
Setting original Formulas for copying | Excel Discussion (Misc queries) | |||
Copying formulas (relative) give always original value | Excel Worksheet Functions |