Dear HR Members
I am doing salary in excel so,
I want excel formula for calculation OF PT and esic ? if gross is more than 5000 then it should come 175 and if gross mare than 10000 then 200 if value is less than 5000 then 0 amount should come. same for esic
Regards
Dilip
From India, Pune
6I am doing salary in excel so,
I want excel formula for calculation OF PT and esic ? if gross is more than 5000 then it should come 175 and if gross mare than 10000 then 200 if value is less than 5000 then 0 amount should come. same for esic
Regards
Dilip
From India, Pune
Here is a formula, however plz cross check before implementing =IF(A5>9999,200,IF(A5>5001,175,IF(A5<5000,0,0))) Regards Atif
From India, Mumbai
From India, Mumbai
Dear Dilip, One change. =IF(A5>9999,200,IF(A5>=5001,175,IF(A5<5000,0,0))) A5 is the gross amount. Regards, Viraj
From India, Pune
From India, Pune
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
EXCEL FORMULA.xls
HR policy excel.doc