Thread: Algebra
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default Algebra

Irish3538 wrote:
I'm not sure if this is even possible, but is there any way to have a cell
have an algebraic equation where entering a number in a specific cell will
run through the equation and spit the number out in that cell? E.g Cell A1
would be "=x+4" so that when you type "2" into cell A1 it would register 6?


For the example you describe, you would simply put the following in A2
(e.g):

=A1+4

You can also give A1 a name so that you could, in fact, type =x+4.