what is the formula if Basic+ DA less or greater than 15000?
can anybody answer me please?
From India, Bangalore
If the amount is equal to 15000 then we give the mentioned formula = sum( Basic+ DA)*12%. ( in salary statement or payroll statement- excel )
what is the formula if Basic+ DA less or greater than 15000?
can anybody answer me please?
i found the answer for this question :
here it is =IF(SUM(D3, E3) >= 15000, 1800, SUM(D3, E3)*12%)
From India, Bangalore
From India, Kolkata
From India, Thane
I have to explain this excel assignment to the students. plz help me. i have send the scanned assignment so that u can know excaltly what i need is formula for DA, TA,HRA, Spl. Allow, EPF, HRD, Tax.
From India, Patna