Hi Ashok,
Appreciate your reply but by deleting if salary above 15000 is not correct format.
Instead u can use this formula in excel =IF(Gross<=15000,Gross*4.75%,0) for permanent format.
Meenakshi
Dear Meenakshi
Your formula one problem no roundup value. so please you help full formula.
THIS IS CORRECT FORMULA IN EXCEL =IF(GROSS>15000,0,ROUNDUP(GROSS*4.75%,0))
Vishnu
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute