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