Sometimes excel office has to input formulas, and some are particularly long, do you have any way?

I can't quite understand your problem, what is the problem that is particularly long causing you?

Let's assume the following:

1. Can't remember: After entering the equal sign, then enter the first letter of the formula, it will associate the corresponding formula, then press up and down, select the formula, then press tab, select the formula, and then press CTRL+A to bring up the function parameter input window.

2. The text is too long: the addition, subtraction, multiplication and division symbols are skillfully used, in the formula, in addition to the operator, they also have the functions of and or;

4. Improve formula skills, for example, grouping through if requires a long formula, and it is very simple to use vlookup;

5. Make good use of plug-ins: such as e-growth, there are other plug-ins, power pivot and power view that come with the software, etc., for big data processing, or personalized formulas;

6. Make good use of the pivot table: Generally, if the conditions are required, the pivot table can be used, including grouping according to a specific step size, and summing of conditions.

7. Use the formula name manager: name your data, which is pretending to be forced, but also short and concise. Or convert the region data into **, which is the same as formula name management.

Enter the equals sign, then enter the first few words, and he'll find them automatically.

For example, this one, type in VL, and then it appears, and you press enter.

In this case, you can create a document, write all the formulas that you often use in the document, and copy and paste it when you use it.

Method steps.

There are a lot of excel functions, and when they appear with a parameter of 0 or empty, you can just keep the "," sign and omit 0

Replace the character a in cell A1 with empty.

substitute(a1,"a","")

Abbreviated as =substitute(a1,"a",)

Simplify with % such as:

Except 100a1 100

Simplified to = a1%.

Replace the if function with another function, such as:

If the value of A1 is greater than 200, the result is 200, otherwise it is still the value of A1.

if(a1>200,200,a1)

Simplified to = min(a1,200).

If the value found in Table 1 is greater than 100, it is displayed as "Overcompleted", "Flat" if it is equal to 100, and "Flat" if it is less than 100"Not finished"

if(vlookup(a1, Table 1!.)a:d,3,0)>100,"Done", vlookup(A1, Table 1!a:d,3,0)=100,"Flat","Not finished")

Simplified to =text(vlookup(a1, Table 1!a:d,3,0)-100,"DoneNot finishedFlat")

Note: The text function is to set the display format of the value by **. Its second parameter is formatted:

Positive numbers are shown as; Negative numbers are shown as; Zero values are displayed as; The text is displayed as"

The excel specification says:

The length of the formula content is 1,024 characters.

If your formula doesn't exceed 1024 characters but you get a hint that the formula is too long, it's usually because of missing or over-entering parentheses, commas, etc. in the formula.

If the formula does exceed 1024 characters. You can reduce the number of characters in a formula by defining a name.

For example, the name of the insert defines x =offset(sheet1!$a$1,,,counta(sheet1!$a:$a),counta(sheet1!$1:$1))

Once the name is defined, you can replace the offset() part of the long formula with x, which greatly reduces the length of the formula. For example, the original formula is.

index(offset(..row(),column())

Once you have defined the name, you can change it.

index(x,row(),column())