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))

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)
--
Gary''s Student - gsnu200736

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.

"Gary''s Student" wrote:

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)
--
Gary''s Student - gsnu200736

debinnyc wrote:
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)

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Just nest the IFs:

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

--
Gary''s Student - gsnu200736


"debinnyc" wrote:

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.

"Gary''s Student" wrote:

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)
--
Gary''s Student - gsnu200736