Preparation of the college paid expenditure table:
The first is regular expenditure;
The second is special expenditure.
1. Find repeat content formula: = if (countif (a: a, a2)> 1, "repeat", "").
2. Calculate the age formula with the years of birth: = Trunc
3. Calculate formula from the birth year of the 18 -digit ID number:
= Concatence (MID (E2, 7, 4), "/", MID (E2,11,2), "/", MID (E2,13,2)).
4. From the input ID number, let the system be automatically extracted from gender, and you can enter the following formulas:
= If (len (c2) = 15, if (MID (MID (C2, 15,1), 2) +1. "Male", "Female), IF (MID (C2,17, 1), 2 ) = 1, "male", "female"))) "C2" represents the cells that entered the ID number.
The college paid expenditure form is a very practical form, and most of the forms of filling the form are commonly used. If you just need to download and download the college -toll expenditure table Excel form, come and download it.General registration form,Inventory entry and exit detailsIt is also a good software, please click to download the experience!
it works
it works
it works