=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8137

[Guest]

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

 

[Biff]

Hi!

Works for me:

=SUM(C14/(1-(Sheet2!F16+0.1)))

Returns: 8137.254901960780000

What result are you getting?

Biff

 

[Jerry W. Lewis]

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

 

[Guest]

Hi!

Works for me:

=SUM(C14/(1-(Sheet2!F16+0.1)))

Returns: 8137.254901960780000

What result are you getting?

Biff




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

 

[Guest]

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]

=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