Input(seperat cell), reference calculating formula(seperate cell), ouput(seperate cell)

[HARRISFAMILYMAN]

I want to create a single formula in a cell that other cells would have values inputted into them and then reference the one formula cell and then in individual cells display the output.

Example: (INPUT CELLS)(I WILL REFER TO THESE CELLS IN THE CALCULATING EQUATION AS "X")
A1=3, A2=5, A3=8

(CALCULATING EQUATION REFERENCE CELL)
B2= X + 5

(OUTPUT CELLS) (AS A RESULT OF THE INPUTS IN A1:A3 THAT RUN THROUGH THE EQUATION IN B2)
C1=8, C2=10, C3=13

 

[BiocideJ]

If I understand your request correctly, something relatively simple like the following should work.

Excel 2007
	A	B	C
1	3		8
2	5	5	10
3	8		13
Sheet1

Cell Formulas
Range	Formula
C1	=A1+$B$2
C2	=A2+$B$2
C3	=A3+$B$2

 

[HARRISFAMILYMAN]

Thank you BiocideJ for responding so quickly, but my issue is a little more involved then that.


I want to create a single formula in a cell that other cells would have values inputted into them and then reference the one formula cell and then in individual cells display the output.

Example: (INPUT CELLS)(I WILL REFER TO THESE CELLS IN THE CALCULATING EQUATION AS "X")
A1=3, A2=5, A3=8

(CALCULATING EQUATION REFERENCE CELL)
B2= X + 5

(OUTPUT CELLS) (AS A RESULT OF THE INPUTS IN A1:A3 THAT RUN THROUGH THE EQUATION IN B2)
C1=8, C2=10, C3=13




I want to make it so that there is only ONE equation in cell B2. All the complication will be in one cell, so that any editing or tweaking of a formula will happen in one cell. If I can do this I can have an infinite amount of output cells that correlate with their respective input cell..... C1 is the result of A1 running through B2, C2 is the result of A2 running through B2, C3 is the result of A3 running through B2. B2 needs to be the BRAIN

I gave a very basic example, but I would use this technique even with complicated formulas that have multiple variables (multiple inputs)

Eventually I wall have list of formulas on a dedicated sheet that the rest of the workbook refers to. One sheet that is the brain of the entire workbook.

Thank you again for your help and any other help you have to offer.