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 -

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 was thinking along the line of an @right formula for formulas
instead of 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 -

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 -

Ok Try this :

=MID(C3,FIND("+",C3,FIND("!",C3)),99)

here i have taken the cell where the data
(=+'[Forecast.xls]June'!$CU$23+3200) is given.

now what i have done is first find "!" mark and then fine "+" sign after
that....this formula will extract "+3200"

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"snax500" wrote:

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 -

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

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 -

Then the formula you have been given by David and by Joel works just fine.
Say, for example, that your formula is in A1, then
=A1-'[Forecast.xls]June'!$CU$23
should work just fine.
--
** John C **

"snax500" wrote:

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 -

On Thu, 6 Nov 2008 13:03:46 -0800 (PST), snax500
wrote:

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

Perhaps if you give some real examples where you tried the attempted solutions,
and show us your original data; how you implemented the recommended solution;
the actual result and the desired result, some one could figure out a proper
solution.

But what you've been repeating has not made clear why the recommended solutions
won't work.

--ron

I have that formual in each month for this years actuals, this years
budget, last years actuals or 12*3 or 36 cells. It just would be
easier if I could of had an @right formual and copied it accross.


On Nov 6, 4:15*pm, Ron Rosenfeld wrote:
On Thu, 6 Nov 2008 13:03:46 -0800 (PST), snax500
wrote:

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

Perhaps if you give some real examples where you tried the attempted solutions,
and show us your original data; how you implemented the recommended solution;
the actual result and the desired result, some one could figure out a proper
solution.

But what you've been repeating has not made clear why the recommended solutions
won't work.

--ron

On Thu, 6 Nov 2008 13:27:39 -0800 (PST), snax500
wrote:

I have that formual in each month for this years actuals, this years
budget, last years actuals or 12*3 or 36 cells. It just would be
easier if I could of had an @right formual and copied it accross.


Perhaps if you give some real examples where you tried the attempted solutions,
and show us your original data; how you implemented the recommended solution;
the actual result and the desired result, some one could figure out a proper
solution.

But what you've been repeating has not made clear why the recommended solutions
won't work.
--ron