| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8
"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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
| help with sumif to calculate column | Excel Discussion (Misc queries) | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| Not able to calculate. | Excel Worksheet Functions | |||
Threaded Mode
