Results 1 to 2 of 2

Gross before percentage applied

Threaded View

nativoft Gross before percentage... 12-05-2015, 08:31 PM
Tony Valko Re: Gross before percentage... 12-05-2015, 08:52 PM
  1. #1
    Registered User
    Join Date
    12-05-2015
    Location
    Australia
    MS-Off Ver
    8.1
    Posts
    1

    Gross before percentage applied

    Hi I am new to the site and a intermediate user of excel.

    I need help in working out a formula or calculation for the following;

    We are contracted fisherman who are paid 31% of the gross catch landed. Our crew are then paid a percentage from the gross catch landed, which is included in the 31% we receive. The contracting company pays the net 31% into our bank account but never lets us know what the gross catch amount was that I need to pay the crew on. I am sick of wasting time each pay to try and workout the gross.

    How would I work this out in excel?

    Example;

    Say we receive 31% of 103225.80 = 32000 rounded up to the closes dollar.

    How do I create a calculation whereby I enter the 31% we receive and it will automatically calculate the gross we were paid on with the included calculation of either rounding up or down to the closest dollar.

    Help would be greatly appreciated.
    Last edited by nativoft; 12-05-2015 at 08:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 2 Percentage Calculation applied to one cell
    By Wiensy11 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2015, 01:14 PM
  2. Will percentage calculation change depending on filters applied?
    By t-money in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2013, 09:15 AM
  3. [SOLVED] Trying to find gross margin value from a percentage input
    By liam_bettinson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2012, 11:43 AM
  4. Gross Pay.
    By craigy09 in forum Excel General
    Replies: 2
    Last Post: 06-25-2012, 01:15 PM
  5. Gross Profit Percentage
    By beaudroix in forum Excel General
    Replies: 2
    Last Post: 03-16-2012, 01:18 PM
  6. Calculating Gross from a Percentage
    By Orangeworker in forum Excel General
    Replies: 2
    Last Post: 12-20-2011, 11:39 AM
  7. Filters applied to creat a percentage pie chart.
    By mark_sheffield in forum Excel General
    Replies: 11
    Last Post: 07-09-2010, 10:33 AM

Tags for this Thread

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