LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel GuRu
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
Again-revealing the contents of formula srinivasan Excel Worksheet Functions 0 July 5th 05 06:25 AM
Initial Formula Calculation jestersdead Excel Discussion (Misc queries) 3 July 4th 05 02:07 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"