#1
|
|||
|
|||
Gross Salary From Net Salary
Hi,
kindly help me with excel formula to work back the Gross Salary from the Net Salary. Given, Net Salary (example)...................2,723.50, S.S.F.........................................5.5% P.F............................................3% NB: Total of 8.5% is deducted from the gross salary to arrive at the chargeable income, on which tax is calculated. The Tax Rates are attached in an excel file named, TAX RATES Thanks in advance for helping me out. |
#2
|
|||
|
|||
Will this do?
|
#3
|
||||
|
||||
Cross-posted (and answered) at: https://www.mrexcel.com/forum/excel-...et-salary.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
I was too tired yesterday obviously - there were a couple miscalculations in attached file.
|
#5
|
|||
|
|||
thanks so much ArviLaanemets,
your solution helps me work the net salary if I already know the gross salary and that's awesome. However, my question is I want to pay someone a Net salary of 2,723.50 and also want to pay SSF(5.5%) and PF(3%), what should the gross salary be? NB: SSF and PF(total |
#6
|
||||
|
||||
I can't open the attachments but in order to get the gross salary, computations must start from the net salary followed by a bit of trial and error in the tax rate. Try the attached sample. It needs input on desired net salary in B7 and the applicable tax rate in B6.
Attachment edited. |
#7
|
||||
|
||||
This post was solved on the cross post
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#8
|
|||
|
|||
Quote:
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Gross salary from Net Salary | E-Major | Excel | 5 | 06-11-2019 11:32 PM |
Formula indicating employees entitled to a salary increase every three years from date of appointmen | Marcia | Excel | 4 | 08-13-2018 03:33 PM |
Salary Structure Calculations | mpapreja | Excel Programming | 9 | 05-14-2018 08:35 AM |
Calculating the “total” based on “salary” value and its “type” (multiple IF), | Jamal NUMAN | Excel | 4 | 07-05-2016 12:34 AM |
VLookup formula Problem (salary plus (commission x sales)) | topgear2015 | Excel | 11 | 06-05-2013 09:02 PM |