Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8137
The equation I am trying to compute is setup using values from diferent sheets.
the 4150 is the total of three cellson sheet 1 divided by 1minus a cell value minus a cell value which gives me a mutiplier to add to a percentage. =sum(C14/(1-('sheet2'!f16+.1))) this is what I have tried to get =sum(4150/(1-(.39+.10))) should = 8137 the problem is in the calculation (1-(.39+.1)) can not figure it out help |
#2
|
|||
|
|||
=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8137
Hi!
Works for me: =SUM(C14/(1-(Sheet2!F16+0.1))) Returns: 8137.254901960780000 What result are you getting? Biff "Dave Keister" <Dave wrote in message ... The equation I am trying to compute is setup using values from diferent sheets. the 4150 is the total of three cellson sheet 1 divided by 1minus a cell value minus a cell value which gives me a mutiplier to add to a percentage. =sum(C14/(1-('sheet2'!f16+.1))) this is what I have tried to get =sum(4150/(1-(.39+.10))) should = 8137 the problem is in the calculation (1-(.39+.1)) can not figure it out help |
#3
|
|||
|
|||
=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8137
When C14 contains 4150 and Sheet2!F16 contains 0.39, then
=SUM(C14/(1-(Sheet2!F16+0.1))) returns 8137.25490196078, as does =C14/(1-(Sheet2!F16+0.1)) i.e. the use of the SUM() function is unnecessary. What result do you get from the formula? If Excel displays the formula instead of the result, then on the menu bar, go to Tools|Opions|View and uncheck Formulas. If the formula is giving you a number between 8057.28155339806 and 8218.81188118812, then C14 and/or Sheet2!F16 do not contain exactly the values that you report. Format them to show more decimal places to see what calculation Excel was performing (formatting affects the display only, not the value in the cell). To calculate with rounded values, you either have to explicitly round, as in =ROUND(C14,0)/(1-(ROUND(Sheet2!F16,2)+0.1)), or else use the menu bar to go to Tools|Options|Calculation and select "Precision as displayed". Jerry Dave Keister wrote: The equation I am trying to compute is setup using values from diferent sheets. the 4150 is the total of three cellson sheet 1 divided by 1minus a cell value minus a cell value which gives me a mutiplier to add to a percentage. =sum(C14/(1-('sheet2'!f16+.1))) this is what I have tried to get =sum(4150/(1-(.39+.10))) should = 8137 the problem is in the calculation (1-(.39+.1)) can not figure it out help |
#4
|
|||
|
|||
=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8
"Biff" wrote: Hi! Works for me: =SUM(C14/(1-(Sheet2!F16+0.1))) Returns: 8137.254901960780000 What result are you getting? Biff "Dave Keister" <Dave wrote in message ... The equation I am trying to compute is setup using values from diferent sheets. the 4150 is the total of three cellson sheet 1 divided by 1minus a cell value minus a cell value which gives me a mutiplier to add to a percentage. =sum(C14/(1-('sheet2'!f16+.1))) this is what I have tried to get =sum(4150/(1-(.39+.10))) should = 8137 the problem is in the calculation (1-(.39+.1)) can not figure it out help This problem consist of three sheets. Sheet1; Cell c3=1800, c4=150, c5=2200 with c4 being the total of all three cells. This total is 4150 This is were the 4150 comes in. the .39 comes from sheet2 D14=1029514 divided by D15=2663427, this total is on D16=sum(D14/D15) All these ar totaled on sheet3 cell D4=Sum('sheet1'!C4/(1-('sheet2'!D16+.1))) the total I get is 8082.38 |
#5
|
|||
|
|||
=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8
Sheet1; Cell c3=1800, c4=150, c5=2200 with c4 being the total of all three
cells. This total is 4150 This is were the 4150 comes in. the .39 comes from sheet2 D14=1029514 divided by D15=2663427, this total is on D16=sum(D14/D15) All these ar totaled on sheet3 cell D4=Sum('sheet1'!C4/(1-('sheet2'!D16+.1))) "Jerry W. Lewis" wrote: When C14 contains 4150 and Sheet2!F16 contains 0.39, then =SUM(C14/(1-(Sheet2!F16+0.1))) returns 8137.25490196078, as does =C14/(1-(Sheet2!F16+0.1)) i.e. the use of the SUM() function is unnecessary. What result do you get from the formula? If Excel displays the formula instead of the result, then on the menu bar, go to Tools|Opions|View and uncheck Formulas. If the formula is giving you a number between 8057.28155339806 and 8218.81188118812, then C14 and/or Sheet2!F16 do not contain exactly the values that you report. Format them to show more decimal places to see what calculation Excel was performing (formatting affects the display only, not the value in the cell). To calculate with rounded values, you either have to explicitly round, as in =ROUND(C14,0)/(1-(ROUND(Sheet2!F16,2)+0.1)), or else use the menu bar to go to Tools|Options|Calculation and select "Precision as displayed". Jerry Dave Keister wrote: The equation I am trying to compute is setup using values from diferent sheets. the 4150 is the total of three cellson sheet 1 divided by 1minus a cell value minus a cell value which gives me a mutiplier to add to a percentage. =sum(C14/(1-('sheet2'!f16+.1))) this is what I have tried to get =sum(4150/(1-(.39+.10))) should = 8137 the problem is in the calculation (1-(.39+.1)) can not figure it out help |
#6
|
|||
|
|||
=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8
=D14/D15 (your use of the SUM function is unnecessary here) equals
0.386537344556468 in Sheet2!F16, not 0.39. As a result, Excel then correctly calculates =C14/(1-(Sheet2!F16+0.1)) to be 8082.379..., not 8137. If you want Excel to use 0.39 instead of the more exact ratio, then you need to use one of the options that I suggested in my previous post. Jerry Dave Keister wrote: Sheet1; Cell c3=1800, c4=150, c5=2200 with c4 being the total of all three cells. This total is 4150 This is were the 4150 comes in. the .39 comes from sheet2 D14=1029514 divided by D15=2663427, this total is on D16=sum(D14/D15) All these ar totaled on sheet3 cell D4=Sum('sheet1'!C4/(1-('sheet2'!D16+.1))) "Jerry W. Lewis" wrote: When C14 contains 4150 and Sheet2!F16 contains 0.39, then =SUM(C14/(1-(Sheet2!F16+0.1))) returns 8137.25490196078, as does =C14/(1-(Sheet2!F16+0.1)) i.e. the use of the SUM() function is unnecessary. What result do you get from the formula? If Excel displays the formula instead of the result, then on the menu bar, go to Tools|Opions|View and uncheck Formulas. If the formula is giving you a number between 8057.28155339806 and 8218.81188118812, then C14 and/or Sheet2!F16 do not contain exactly the values that you report. Format them to show more decimal places to see what calculation Excel was performing (formatting affects the display only, not the value in the cell). To calculate with rounded values, you either have to explicitly round, as in =ROUND(C14,0)/(1-(ROUND(Sheet2!F16,2)+0.1)), or else use the menu bar to go to Tools|Options|Calculation and select "Precision as displayed". Jerry Dave Keister wrote: The equation I am trying to compute is setup using values from diferent sheets. the 4150 is the total of three cellson sheet 1 divided by 1minus a cell value minus a cell value which gives me a mutiplier to add to a percentage. =sum(C14/(1-('sheet2'!f16+.1))) this is what I have tried to get =sum(4150/(1-(.39+.10))) should = 8137 the problem is in the calculation (1-(.39+.1)) can not figure it out help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
help with sumif to calculate column | Excel Discussion (Misc queries) | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Not able to calculate. | Excel Worksheet Functions |