| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
=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 |
| 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
