Real estate tax declaration formHow to fill in?
1. Real estate tax is an individual property tax in property tax, and its taxation target is only houses;
2. The scope of collection is limited to the operating houses of the town;
3. Different from the operation and use of houses, the tax collection method is required, levy for the tax balance value of the real estate, and levy taxes for rental houses by rent.
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" in the formula represents inputID cardUnit of number.
Xiaobian recommended by Huajun Software Park
Real estate tax declaration formIt is a very practical form, and most of the forms of filling the form are commonly used. If you just need the real estate tax declaration form, come and download it. also,Salary table template,Financial statement templateIt is also a good software, please click to download the experience!
it works
it works
it works