> =IF($H$2 <= indirect("'C:\Documents and Settings\All Users\Documents\Budget
> \Finances\2010\[Budget_Estimation_Tys.xls]Sheet1'!" & G2),
> ,"Within budget","Over budget")
>
> should work..
> (although I don't know if you
(although I don't know if you need the single quotes ('))
I'd first try the formula using named ranges, then
replace the named range with the Indirect() function.
Paul
- Original Message
> From: Susan
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, October 13, 2
Here is my formula
=IF($H$2<='C:\Documents and Settings\All Users\Documents\Budget
\Finances\2010\[Budget_Estimation_Tys.xls]Sheet1'!$B$2,"Within
budget","Over budget")
H2 is the Average per month calculation , this is correct and the
formula is working correctly for averaging.
B2 is the estimat
A lot is going to depend on what your data looks like and what
you're trying to accomplish.
For instance
To ME, when you say that you want the "formula" to change,
my first interpretation is that if you select "Groceries",
you want the average, but if you select "Utilities",
then you want th
