Hurry, hurry, hurry! Excel Function Formula 10

if(b8="Single door",max(2,g13),if(b8="Double door Mother-in-law door",max(,g13),""))

If there are two types of double door and mother and son door, use the following formula:

if(b8="Single door",max(2,g13),if(or(b8="Double doors",b8="Mother and son door"),max(,g13),""))

1. You need to use two formulas: addition (basic salary + performance salary) and subtraction (total salary, salary deducted from sick leave), and you need to put the mouse on the number grid.

Then press the number key and then use the mouse to click a added number, then press the + key on the keypad, and then click another added number, and the middle symbol becomes the - sign on the keypad when subtracting.

2. Click the enter key on the keyboard, and the calculated number will be displayed in the number **. Take advantage of the ability to copy cells. Hover over the lower-right corner of the number of **.

Press the left mouse button, a black + wordmark will be displayed on the computer, pull down the mouse, and the following ** will also be substituted into the calculated formula. How many squares can be pulled.

3. Save the good ** and open it next time you need to use it. If you need to do a lot of the same kind of **, such as the monthly salary value will be different.

You can copy or create a copy of the finished **, and you can copy the finished ** with a formula.

4. The operation of multiplication and division is the same as that of addition and subtraction, and the division sign is the slash on the keypad. In addition, the data on ** can be changed. When the previous data is changed, the number of formulas will change accordingly.

The use of formulas is a very useful feature. A lot of ** can be used.

Select the data, insert a scatter plot (horizontally and vertically), and add a trend line. Set and check the display formula.

Let's go up and describe what you want to achieve.

Version may not work 2016 can.

Extraction code: fs1m If you can use Excel to organize ** quickly, accurately and beautifully, you will become a logical person in the eyes of the boss. If you can use excel charts to make the boss see the results at a glance, you will become a reliable person in the eyes of the boss.

If you can use excel to mine and analyze data information, you will become an irreplaceable person in the eyes of your boss. This time, NetEase Open Class invited Excel senior lecturer - Yake teacher to bring you a super practical and systematic Excel course "36 Lessons, Realizing the Advancement of Excel from a novice to a master".

Course Catalog. 4 ways to import data in bulk.

Tutorial: How to learn excel correctly

Lesson 2 OCR technology for rapid entry.

Lesson 3: How to import data from a web page.

Lesson 4: How to use Jiandao Cloud to quickly collect data.

A 10x easier way to enter data.

Lesson 5 Data Specification: Without standardization, everything is busy.