Get Part of Cell

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

=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

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:
=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 -

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 -

If you want a formula to give you 150, the formula is =150
--
David Biddulph

"snax500" wrote in message
...
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:
=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 -

Ok, here is another example, I have the following example, in cell
A1...


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

in cell A2, I want a formula to read A1 and give me just the +3200.
Cell A2 will equal +3200.

Thanks











On Nov 6, 3:34*pm, "David Biddulph" groups [at] biddulph.org.uk
wrote:
If you want a formula to give you 150, the formula is =150
--
David Biddulph

"snax500" wrote in message

...
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:







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

Ok, here is another example, I have the following example, in cell
A1...


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

in cell A2, I want a formula to read A1 and give me just the +3200.
Cell A2 will equal +3200.

Thanks



On Nov 6, 3:34*pm, "David Biddulph" groups [at] biddulph.org.uk
wrote:
If you want a formula to give you 150, the formula is =150
--
David Biddulph

"snax500" wrote in message

...
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:



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

To start with, you don't need =+ at the start of your formula. Just = will
do.

You've already been told the answer to your question by Joel. If A2
contains =[Forecast.xls]June!$A$47+300 and you want to return 300 in another
cell, the formula will be =A2-[Forecast.xls]June!$A$47
--
David Biddulph

"snax500" wrote in message
...
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.


=A2-A1

I was thinking along the lines of an @right but with formulas not
text.




On Nov 6, 3:47*pm, "David Biddulph" groups [at] biddulph.org.uk
wrote:
To start with, you don't need =+ at the start of your formula. *Just = will
do.

You've already been told the answer to your question by Joel. *If A2
contains =[Forecast.xls]June!$A$47+300 and you want to return 300 in another
cell, the formula will be =A2-[Forecast.xls]June!$A$47
--
David Biddulph

"snax500" wrote in message

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

=A2-A1- Hide quoted text -

- Show quoted text -

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