Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula calculation
Is there a way to setup multiple formulas so they calculate in a specific
order? I have a complicated financial model that we use for budgetting. After we change assumptions, we get errors in our formulas. What we have to do, is trace the cells back to the error (using the auditing tools) and delete the formula calculating the error and then undo the deletion. Only trouble is, you have to do that many times to get everything calculating properly. Problem is created by the following: we are trying to calculate net income after tax. We need to calulate interest income(expense) based on the monthly cash position which in some cases is calculated on the cash position after the tax payment. Only trouble is, tax is calculated on net income before tax, which is after interest income. Understand the dilemma? I'm hoping somebody has a solution they could suggest. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Again-revealing the contents of formula | Excel Worksheet Functions | |||
Initial Formula Calculation | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |