Combining Information from two cells into one

[JaredMcCullough]

ok basically here is the issue i have to values: one in cell C12 lets say its

7 and in cell U13 its 8 is there any way i can make a command in cell B14

to show the multiplication of these two so it would be C12*U13 values in

cell B14 thus in this situation 7*8 but these numbers will change quite

often so i need it to be a command that way when they change it will

automatically adjust

 

[hiker95]

JaredMcCullough,


If we start with this:

Excel Workbook
	B	C	U
12		7
13			8
14	56
Sheet1

And, if we change C12 from 7 10 11 we get this:

Excel Workbook
	B	C	U
12		11
13			8
14	88
Sheet1

And, if we change U13 to 20 we get this:

Excel Workbook
	B	C	U
12		11
13			20
14	220
Sheet1

Make sure that Tools, Options, Calculation, is set to Automatic.

 

[JaredMcCullough]

Thank you very much now i was wondering is there anyway i could

get the values to appear in cell A14 to show that these two numbers are

being multiplied. Basically Cell B14 is the product of the equation that was

provided but is there any way to show that equation in the cell before but

have it so that if either of the cells (C or U) is changed the values change

along with it??