Skip to content

video not played or not found error
click on direct switch

Hosted by Dailymotion. For legal issues: Copyright Center · DMC · Instant Removal

excel salary sheet and formula

F
free learning center

21 Views • Oct 10, 2017

Description

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