Net to Gross Formula

[gsuresh123]

Hi,
I'm looking for salary calculator which calculate Gross Salary if we input Net Salary. The Components bifurcation is as follows:
Basic Salary: 70% of Gross Salary
HRA: 30% of Basic Salary

ESIC: Gross Salary*0.25%(if Gross salary is Greater than 21,000, ESIC=0)
EPF:Basic Salary*12%(If Basic Salary is greater than 15,000, EPF=0)
PT:If Gross is Less than 15000 than PT =0, If Gross is Greater than 15,000 and Less Than 20,000 then PT=150 , If Gross is greater than 20,000, PT=200

Based on the above criteria, please help me in calculating Gross Salary if I Input Net Salary in Excel.

Thanks & Regards
Suresh
9959172919

 

[Fluff]

Duplicate Need Salary Calculation from Net Salary to Gross Calcuation

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).