Thread
:
=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8137
View Single Post
#
2
Biff
Posts: n/a
=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
Reply With Quote