gross

Guys help me to make this code: A company has 10 employees, they all get paid on hourly basis. For each employee the company keeps h employee name, number of hours worked every week. Every employee gets paid weekly. Gross earning is calculated by multiplying number of hours worked by pay per...

Trying to setup a spreadsheet to do this but here's the grid below. Bonuses are ONLY given on the amount between the threshold. For instance, if you do 500K of commission and fee's, you get a bonus on tier 1 on 99,999 of production, then you also get a bonus on the 299,999 of production. You...

HELLO EXPERTS, I NEED TO WRITE A SIMPLE SQL TO EXTRACT DATA FROM A TABLE. TABLE IS ALREADY EXTRACTING DATA FROM MULTIPLE FILES AND IS REFRESHING WELL WHEN DATA IS UPDATED IN SOURCE FILES. NOW FROM THIS TABLE I NEED TO WRITE COUPLE OF COMMANDS / SQL IN DIFFERENT SHEETS / WORKBOOKS WHICH MAY...

Hi I want a formula to pick 1st word from the sentence , please help Jack & Jill = Jack Please come = Please Gross Margin = Gross

I am working on a salary sheet and stuck on this situation. Sheet has a to z columns with these headings. What i need is, if employee name and employee code repeat several times, then i get sum of his duty, wages, pf, esi, pt, gross salary, advance, uniform, add money, take home, bank cheque...

Hi please I need urgent excel help to find the gross salary, given the Net salary in Ghana Net salary( example)....... 2,723.50 S.S.F............................5.5% P.F...............................3% NB: (S.S.F. and P.F. are deducted from the gross salary before arriving at chargeable...

I would like to add an additional row in my pivot table for percent of Gross Sales below each of the following categories. Any idea if this can achieved? Gross Sales POD Expense Commissions Rebate Discount Freight Costs Net Sales $4,69,655 $293,212...

Hi there, sorry if this has been answered somewhere else but the closest thread I could find was this one and it's not quite what I need. https://www.mrexcel.com/forum/excel-questions/759322-work-backwards-desired-commission-amount-find-sales-volume.html Real estate agents for a brokerage are...

I'm not sure this is even possible, but here goes, is there a way to put the below instructions into a macro. Use the takeover lists for rental from NRC to delete adjustments which $0.00 each other out. – filter on Takeover under Agreement field, copy Acct# and T/O from acct# (column C & P)...

Hi Guys, I need help. I want to use Web Query in my Excel Sheet to show the Gross Sales of the movies that I am looking for. Information about the movies are in columns A and B. Column A contains the title, column B has the year when the movie was released. Column C to E will displayed the...

Im trying to create a formula with the following parameters: lets say you have: 1,000,000,000: and you get: $1K for each $1mm (Gross) up to $50mm $0.75K for each $1mm (Gross) from $51-$150mm $0.5k for each $1mm (Gross) from $151-$500mm $0.2k for each $1mm (Gross) from $501mm-$750mm...

hi, was wondering if someone could help. this is probably simple but has my head a bit messed. basically i want to do a formula where if the values of two cells dont match something then sum 3 cells to give a total. in one column i have account. and in the other i have department. i want the...

Hi there. I have the following code, looking for all text to the left of "Gross". Is there a way to update this to show text to the left of either "Gross" or "Net"? Thank you =TRIM(LEFT(A2,MIN(FIND({"GROSS"},A2&"GROSS"))-1))

I am in the middle of creating a financial worksheet for myself and my coworkers. I am having trouble figuring how much time we worked for free due to taxes. I have my tax rates calculated. I have my gross rates calculated. For example: I work 10 Hours, My pay is $50. So my gross rate is...

I have tried and tried many ways and cannot get a formula to work. PLEASE HELP! I am setting up a spreadsheet to calculate sales commissions. The tiers are: $0-$40,000 @ 50/50 $40,001-50,000 @ 60/40 $50,001-$60,000 @ 70/30 $60,001-$70,000 @80/20 $70,001 & up @ 90% It is cumulative...

Hi, I have two sheets of orders from different sources and want to check if the gross price is the same for each order line. However as the order number is repeated (for each product line) I cant use a vlookup. Can anyone help with an index/match formula...

Hi Guys I need to have a textbox that shows the nett value before VAT from a Gross value I have a UserForm with the following textboxes: TextBox1 where the user enters the Gross value TextBox2 where the user enters the applicable VAT Rate [default is set to 20] TextBox3 is to contain the Nett...

Hello all. Could anyone teach me how to find gross salary if I have a net pay of 12,204,000? The gross is 13,742,520 but I don't know how to build a auto calculate table in excel <tbody> </tbody> ex: 13,742,520 goes range 20%. so 13,742,520 x 20% = 2,748,504 - 1,210,000 = 1,538,504 tax...

Hello all I am currently using a macro to email an active line from a workbook, all works ok except the Gross profit figure show in the email body as 15.6367342 How can I code tag or format the code to show only one decimal point please 15.6 GP = Range("I" & ActiveCell.Row) objmail.Body =...

Hi- I have created a pivot table and want a % calculation on a row. I can not use calculated fields as it is an item in a field and I can not used calculated items as the items are in two different fields. For anyone financially minded it is a gross profit %. I have my pivot displaying total...