excel salary sheet and formula

excel salary sheet and formula

Excel salary statement includes employees basic pay,house Rent, Medical allowance, Convince Allowances, Income Tax and some other allowances. br Formula: =IF(E3=30000,E3*20,IF(E3=20000,E3*15,IF(E3=15000,E3*10,IF(E3=10000,E3*7,E3*5 br while E3 is the excel sheet location E is the Column and 3 is the spreadsheet row Number.


User: free learning center

Views: 19

Uploaded: 2017-10-10

Duration: 21:01

Your Page Title