 Tips for using college class fee expense table
 
Tips for using college class fee expense table 
Preparation of university class fee expenditure table:
	   First, recurring expenditures;
The second is special expenditures.
	  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")) The "C2" in the formula represents the cell where the ID number is entered.
The college class fee expense form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the college class fee expense form Excel form, download it quickly.Universal Registration Form,Inventory entry and exit details listIt is also a good software. Welcome to click to download and experience it!

 
             
                 
                                     
                                     
                                     
                 
                 
     
     
     
     
     
     
     
    



















 
 
            
Useful
Useful
Useful