How to set the product formula between columns in an Acess table

Fill in a series of numbers, the cursor is positioned in the last box, click "**"-"Formula" in the menu, and fill in the formula "=product()" in the pop-up dialog box "If you want to product all the values above the grid, you can write it as "=product(above)", if you want to product all the values on the left side of the grid, you can write it as "=product(left)", The above basic operation is actually written into a "field" where you need to automatically fill in the calculation result, so you can also insert "field" - formula to operate. So-called"Formula"In fact, not only can you use functions here, but you can also mix functions with mathematical calculation symbols and write them as a "formula", such as asking for the product of cells 1 and 2 in the first row of ** and subtracting the product by 20, then the "formula" can be written as: =product(a1,b1)-20

In addition, it should be noted that when the value you fill in in front of or above changes, the value automatically generated in the formula will not change automatically (it will change automatically in excel), you should use the right click - "Update Field" to update it to avoid errors.

After understanding the above operations, you should think of such as summing the ** value, finding the average, finding the maximum value, finding the minimum value, ......It's all about that.

** >> Formula >> Select =product() in the function, and write the cells you want to multiply in parentheses, for example, calculate the first row of 1, 2 cells are: =product(a1,b1).

e5=lookup(9e+307,left(c5,row($1:$20))*1)*lookup(9e+307,left(d5,row($1:$20))*1)

It is recommended that the table units be displayed in a custom format.

Enter the formula in cell E5.

lookup(,-left(c5,row($1:$20)))lookup(,-left(d5,row($1:$20)))

Pull-down padding.

It's not easy to do, the unit is not unified, there are characters and Chinese characters. Let's wait for the other gods to solve it.

Enter =A1*B1 in C1, then point the mouse to the lower right corner of cell C1, and hold down the left button to drag down when the cursor changes to a solid black cross.

Put the cursor at the bottom right of cell e2, when the cursor becomes a solid cross, click to put it down and drag it for a long time...

Place the cursor in the lower right corner of e2 and double-click it when it becomes a black cross.

I don't know what you mean by the product formula? The simplest is to directly enter =number*number in the cell, and press enter.

The * sign is the multiplication symbol, such as 1+2x5, write "=1+2*5" in the electronic **, and the result 11 will be displayed

The * sign of the keypad is the multiplication symbol, and you can list the formula according to the mathematical method.

Fill in 2 in any blank cell, then right-click on the cell, copy, then select all the areas where you want to multiply by 2, then right-click, paste specially, select "multiply" in the arithmetic, OK.