View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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 -