View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Assigning Values to Symbols

If you want Names for this you may for instance Name(Insert, Name,
Define) cell A1 "p" and Name cell A2 "pOne". Now put =1 in cell A1 and
=.5 in cell A2. Now click in another cell and put =p+pOne, and it should
show 1.5



George wrote:
I want to be able to insert symbols such as a letter (p) or a letter and
number (p1)into a worksheet. I then want to created a formula that
recognizes those symbols as a specific value, such as p=1 and p1 -.5. Could
anyone tell me how to do that?

Thanks