Logical Formula

[debinnyc]

I am trying to build a formula that if values change, the formula changes.
For example, if there is a small column of numbers such as line budgets. If
those budgets are revised, the new budget would be placed in the next column,
with a max of two revisions. I have an actual YTD costs, and a balance
formula. What I need is for the balance formula to calculate against the
budgeted amount (i.e. =budget-YTD). So if the budget is revised, I want the
balance to automatically consider the revised amount, not the original
amount.
I have tried using the IF stmt, but I cannot get the formula to consider the
revisions. Can anyone please help? Below is what I have tried, based on help
from here. Thanks

=IF(G74<>"",G74-I74,IF(E74<>"",E74-I74,C74-I74))

 

[Gary''s Student]

Consider the original budget in column A. Any revisions to the original
budget in column B. Entries in column B will be empty until a revision is
made. YTD Actuals will be in column C. The calculation is in column D. In
D1:

=IF(B1="",A1-C1,B1-C1)

 

[debinnyc]

What if there is a second column for revision, for instance:
Budget-A
Rev1-B
Rev2-C
YTD-D
Calc-E

How would it change? Thanks for your help.

 

[Dave D-C]

I am trying to build a formula that if values change, the formula changes.
For example, if there is a small column of numbers such as line budgets. If
those budgets are revised, the new budget would be placed in the next column,
with a max of two revisions. I have an actual YTD costs, and a balance
formula. What I need is for the balance formula to calculate against the
budgeted amount (i.e. =budget-YTD). So if the budget is revised, I want the
balance to automatically consider the revised amount, not the original
amount.
I have tried using the IF stmt, but I cannot get the formula to consider the
revisions. Can anyone please help? Below is what I have tried, based on help
from here. Thanks
=IF(G74<>"",G74-I74,IF(E74<>"",E74-I74,C74-I74))

Your formula works for me
100 101 102 90 xxx
xxx = =IF(C1<>"",C1-D1,IF(B1<>"",B1-D1,A1-D1))
gives 12 (102-90)

 

[Gary''s Student]

Just nest the IFs:

=IF(C1="",IF(B1="",A1-D1,B1-D1),C1-D1)