=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
|