Thanks John but it is a corporate form that can not be changed. I am
stuck with it the way it is

='[Forecast.xls]June'!$CU$23+3200

If anyone else has any other ideas I would appreciate it, like find
the "+" and give me everything to the right of it.

Thanks




On Nov 6, 3:56*pm, John C <johnc@stateofdenial wrote:
I don't understand why the solutions given do not work for you? This number
you are adding is static. Why do you need a formula to tell you a static
number for other cells?
I guess the only reason I can think of is that at times, this number will
change, and you want all other references to still remain the same.
I recommend the following in that case:
A1: ='[Forecast.xls]June'!$CU$23+$A$2
A2: 3200 *.... or if you prefer =3200
--
** John C **



"snax500" wrote:
In cell A1, I have 100. In cell A2, I have +A1+150 or 250. I need a
formula for cell A3 that points to cell A2 and gives me just the +150
part of the formula so that A3=150.

Thanks- Hide quoted text -

- Show quoted text -