Kait for leave approval formHow to fill in?
1. Seek truth from facts, do not exaggerate, avoid suspicion of "making excuses".
2. I have a hand book, and the leave of the leave is generally handwritten by me. Special circumstances can be written by others, but you need to explain in the text that if you print it, the name of the money must be handwritten.
3. Simply and clear words, and the leave bar must be concise and clear. Generally, only the reason for writing clearly, the time and hope of the leave of leave, and the hope of getting approved.
4. Take a leave of time, this is very important, it must be put on, clear.
5. Wishes. Bless the other party, this is the friendship of all the official documents.
6. Signature of the fake person. Your own signature does not need to press the fingerprint, you only need to sign.
7, leave time. Fill in the current time you wrote a fake bar.
The total subsidy of the statistical department for production and position is mainly based on posts.
The formula is:
= Sumifs (D2: D9, B2: B9, F2, C2: C9, G2)
2: Condition count
Statistically count the number of business pens of specified stores. That is, how many designated shop names are there in column B.
= Countif (B2: B12, E3)
3: Multi -condition search
The query department is required to be produced and the name is the minister.
The formula is:
= Lookup (1,0/((b2: b9 = f2)*(C2: C9 = G2)), A2: A9)
The LOOKUP function multi -condition query writing is:
= LOOOKUP (1,0/(((Condition area 1 = condition 1)*(condition area 2 = condition 2), query area)
4: Calculating text calculation
To calculate the text format in the cell, first click the first cell to enter the formula to define the name:
Calculation = Evaluate (C2)
Then enter the formula in the cell:
= Calculate
Xiaobian recommended by Huajun Software Park
Kait for leave approval formIt is a very practical form, and most of the forms of filling the form are commonly used. If you just need to ask for the approval form, come and download it. also,Account password management table,Total table of employee bonusesIt is also a good software, please click to download the experience!
it works
it works
it works