Excel Formula [Thread 261458]

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

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

Dear Dilip,
One change.
=IF(A5>9999,200,IF(A5>=5001,175,IF(A5<5000,0,0)))
A5 is the gross amount.
Regards,
Viraj

if any copy formula in ms excel yes or not
if yes i copy one cell figer to another cell
pl.reply me