+ Reply to Thread
Results 1 to 2 of 2

Formula to build net to gross calculation

  1. #1
    Registered User
    Join Date
    05-17-2021
    Location
    Sofia
    MS-Off Ver
    2016
    Posts
    1

    Formula to build net to gross calculation

    Hi everyone,

    Could you guide me on which formula is the correct one to use to do a net to gross calculation? I have the net and want to more easily calculate the gross up of it.
    In the attached is what I used to build it gross to net, now trying to reverse it / do it the other way around, tried vlookup, what-if analysis, searched online but I'm doing smth wrong and not sure anymore if one formula could work at all.

    It's a marginal tax rate and pension is deductible ie. Net salary = Gross salary - pension - income tax.

    I guess I can do it if I know which are the correct formulas and logic.

    Thanks a lot in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,341

    Re: Formula to build net to gross calculation

    See here for your TAX calculation

    http://www.mcgimpsey.com/excel/variablerate.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF / find spec - Gross Weight calculation
    By Galaxy1986 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-21-2020, 11:49 AM
  2. Gross Distribution Calculation
    By jenstrymecki in forum Excel General
    Replies: 3
    Last Post: 10-01-2019, 04:39 PM
  3. Calculation of gross margin
    By perfekt448 in forum Excel General
    Replies: 3
    Last Post: 04-24-2019, 09:48 AM
  4. [SOLVED] Gross Pay Calculation Error
    By Billy Spivy in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-10-2018, 08:37 AM
  5. Derive Gross Pay plus Payroll Taxes from a Gross Amount
    By JackJack185 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-09-2017, 03:56 PM
  6. Net to Gross Calculation, payroll
    By bilbonvidia in forum Excel General
    Replies: 4
    Last Post: 08-10-2013, 04:28 PM
  7. [SOLVED] Calculation of Gross Margin in a pivot table
    By Martin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2006, 02:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1