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