1. According to your requirements, enter 1- 10 as the base of summation, as shown in the following figure:

2. If you need to multiply the number in another cell by a different value, please use the multiplication formula as follows:

3. At this point, if you need to add the multiplied results to calculate the results, you need to copy and paste the values that have not been multiplied into the new cell list, or use the equal sign formula, as shown in the following figure:

4. Finally, use the total formula in the new cell list, as shown below:

5. The final results are as follows:

The following are:

EXCEL formula is an equation used for numerical calculation in EXCEL worksheet. Formula input starts with "=". Simple formulas include addition, subtraction, multiplication and division.

More complex formulas may contain functions (functions: functions are pre-written formulas that can perform operations on one or more values and return one or more values. Functions can simplify and shorten formulas in worksheets, especially when formulas are used to perform long or complex calculations. ), reference, operator (operator: a sign or symbol that specifies the type of calculation performed in an expression.

There are mathematics, comparison, logic and reference operators. ) and constant (constant: a value that is not calculated, so it will not change. )

Operator classification: arithmetic operator, comparison operator, text operator and reference operator.

1. Arithmetic operator: Arithmetic operators are used to perform basic mathematical operations, such as addition, subtraction and multiplication. The arithmetic operators are ten (addition), one (subtraction), * (multiplication),/(division),% (percentage) and (power).

2. Comparison operator: The comparison operator is used to compare two numerical values, and the result is a logical value of True (true) or False (false). Comparison operators are = (equal to), > (greater than), > = (greater than or equal to), < = (less than or equal to), <> (not equal to).

3. Text operator: the text operator "&"is used to connect one or more texts into a combined text. For example, "micro"&; The result of "soft" is "Microsoft".

4. Reference Operator: The reference operator is used to merge cell ranges. The reference operator is:

A range (colon) refers to cells in all areas between two references, including two references, such as sum (bi: d5).

Union (comma) means combining multiple references into one reference, for example, SUM(B5, B 15, D5, D 15).

Crossing (space) means generating references belonging to two reference cell areas.

Excel formula? Baidu baike