How to add unit multiplication formula in Excel table?

How to use unit multiplication formula in Excel table: first open the table and enter the corresponding data; then enter the formula in cell C1 [=LEFT(A1,FIND("jin",A1)-1)*LEFT (B1,FIND("元",B1)-1)】; If the final unit is inconsistent, you can modify it.

Excel table with unit multiplication formula method:

1. Open the excel table;

2. Enter the data for the corresponding demonstration;

3. We enter the formula in cell C1: =LEFT(A1, FIND("jin",A1)-1)*LEFT(B1,FIND("元",B1)-1) and click OK;

4. At this time The corresponding result is displayed;

5. If the unit is different from the above demonstration, modify it in the formula;

6. Addition, subtraction, multiplication and division are all possible, ,-,*,/.

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to add unit multiplication formula in Excel table?. For more information, please follow other related articles on the PHP Chinese website!