Report items included
1. Operating income
Less
Taxes and surcharges
Sales expenses
Management expenses
Financial expenses
Asset impairment loss
Add: Gains from changes in fair value (losses are listed with a "-" sign)
Investment income (losses are listed with "-")
Investment income from associates and joint ventures
Asset disposal income (losses are listed with "-")
Other income
1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").
2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
4. To let the system automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1."Male","Female), IF(MOD(MID(C2,17, 1),2 )=1,"Male","Female")) "C2" in the formula represents the cell where the ID number is entered.
The financial statement and income statement is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need to download the financial statement and income statement Excel form, please download it quickly.Express delivery and receipt registration form,Company vehicle registration formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works