Get Part of Cell
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 -
|