Excel multiplication formula 1, A 1*B 1=C 1.

First, open the table and enter the multiplication formula "=A 1*B 1" in cell C 1. After typing, you will find that "0" will be displayed in the cell of C 1. Of course, because the data to be multiplied has not been entered, it will naturally display 0.

Now, enter the data to be multiplied in cells "A 1" and "B 1" to multiply, as shown in the figure, enter 10 and 50 in cells A 1 and B 1 respectively to multiply, and the result will be displayed in C 1

2. Multiplication formula of multiple cells in 2.Excel

Enter the multiplication formula "= a1* b1* c1* d1"in the cell E 1. Then enter the data to be multiplied in A 1, B 1, C 1 and D 1 in turn, and the result will be displayed in E 1.

The functions commonly used in Excel include, COUNT to calculate the number of values, ROUND rounding, RAND random number, MIN minimum value, SUN sum, AVERAGE, IF condition, etc. Select a cell, click the Edit Formula button, select a function and click OK, enter parameters and click OK to use the function.

ROUND means rounding, RAND means random number, MIN means minimum value, MAX means maximum value, SUN means sum, AVERAGE means average, and IF means condition.