Microsoft Office Forums Gross Salary From Net Salary

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-12-2019, 03:45 AM
E-Major E-Major is offline Gross Salary From Net Salary Windows 7 32bit Gross Salary From Net Salary Office 2013
Novice
Gross Salary From Net Salary
 
Join Date: Jun 2019
Posts: 5
E-Major is on a distinguished road
Default 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.
Attached Files
File Type: xlsx TAX RATES.xlsx (9.4 KB, 3 views)
Reply With Quote
  #2  
Old 06-12-2019, 07:50 AM
ArviLaanemets ArviLaanemets is offline Gross Salary From Net Salary Windows 8 Gross Salary From Net Salary Office 2016
Expert
 
Join Date: May 2017
Posts: 446
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

Will this do?
Attached Files
File Type: xlsx TaxRates.xlsx (13.0 KB, 3 views)
Reply With Quote
  #3  
Old 06-12-2019, 05:24 PM
macropod's Avatar
macropod macropod is online now Gross Salary From Net Salary Windows 7 64bit Gross Salary From Net Salary Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,480
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #4  
Old 06-13-2019, 12:50 AM
ArviLaanemets ArviLaanemets is offline Gross Salary From Net Salary Windows 8 Gross Salary From Net Salary Office 2016
Expert
 
Join Date: May 2017
Posts: 446
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

I was too tired yesterday obviously - there were a couple miscalculations in attached file.
Attached Files
File Type: xlsx TaxRates.xlsx (13.5 KB, 2 views)
Reply With Quote
  #5  
Old 06-13-2019, 02:29 AM
E-Major E-Major is offline Gross Salary From Net Salary Windows 7 32bit Gross Salary From Net Salary Office 2013
Novice
Gross Salary From Net Salary
 
Join Date: Jun 2019
Posts: 5
E-Major is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 06-13-2019, 08:04 PM
Marcia Marcia is offline Gross Salary From Net Salary Windows 7 32bit Gross Salary From Net Salary Office 2013
Competent Performer
 
Join Date: May 2018
Location: Philippines
Posts: 192
Marcia is on a distinguished road
Default

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.
Attached Files
File Type: xlsx Gross Salary.xlsx (8.8 KB, 1 views)
Reply With Quote
  #7  
Old 06-13-2019, 11:30 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Gross Salary From Net Salary Windows 7 64bit Gross Salary From Net Salary Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,382
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

This post was solved on the cross post
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #8  
Old 06-13-2019, 11:54 PM
E-Major E-Major is offline Gross Salary From Net Salary Windows 7 32bit Gross Salary From Net Salary Office 2013
Novice
Gross Salary From Net Salary
 
Join Date: Jun 2019
Posts: 5
E-Major is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Noted, would not be repeated.... Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gross salary from Net Salary E-Major Excel 5 06-11-2019 11:32 PM
Gross Salary From Net Salary 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
Gross Salary From Net Salary 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


All times are GMT -7. The time now is 06:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft