2 2 =A1*B1
produces correct result, but when copied to a new row the formula make static reference to Row1.
I tried this and it works
2 2 =PRODUCT(LEFT)
BUT must be able to explicitly select which column in the formula.
Can anyone tell me a specific keyword or have some other formula to use a cell reference on the same row as the formula?