On Nov 6, 3:16*pm, snax500 wrote:
I don't want the difference. I want a formula to pull out the 150 so I
can use it in another part of my file.

On Nov 6, 2:58*pm, Joel wrote:


Another example is if I had a cell with this formula - A1...

=+[Forecast.xls]June!$A$47+300

and in another cell -A2 - I have a formula that looks up cell A1 and
gives me just the +300 of the formula.

thx



=A2-A1

"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 -- Hide quoted text -

- Show quoted text -