The formula that you need for the multiplication table is a formula that will multiply whatever is in row 1 by whatever is in column A.
To have a reference that always points to row 1, use something in the format of X$1. To have a reference that points to column A, use a reference in the format of $An.
To have a reference that always points to row 1, use something in the format of X$1. To have a reference that points to column A, use a reference in the format of $An.
First, create something like:
Then enter $A2*B$1 into B2.
Next, copy the formula in B2 to the entire area and you will get the expected output:
No comments:
Post a Comment