"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