View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default =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