formula: compute for total commission = total sales * commision

compute for the gross pay = net pay + total commission

compute for the gross pay = net pay + total commission

- Determine the commission
- Formula to calculate the hours worked and gross amount earned
- Calculate the total commissions
- Training: Prepare for the holidays: Write and send a newsletter with Word
- Copy price range for the specific age and gender in the receipt sheet
- Create a total for commissions based on commission number
- Gross pay Calculator
- Sum the total and find the average cost
- Returning the total number and the qty.
- IN EXCEL...I CANNOT COPY THE TOTAL LINE AND PASTE IT ...I GET REF.
- Computing the Hours Worked
- Formula and computation for timesheet with workschedule
- Formula for obtaining the total running time from the time code
- calculating the total from a running totalizer that resets
- Help! Formulas for dates, excluding holidays and weekends
- Need a formula to add the total # each time it finds a name
- How to keep the total colum
- Look for similar text and find the largest value and return value
- Using an IF function for a total
- Need a formula to add the total # each time it finds a name
- Number of product use for the day or week
- Counting the days worked and days remaining on a schedule automatically
- Computing for number of hours under Night Differential
- Search and delete the result plus the cell below, and then loop

compute for the total commission = total sales * commission

compute for the gross pay = net pay + total commission

*create remarks column after gross pay based on the following assumption:

if total commission is greater than 10,000 remark is "Good Job"

if less, remarks is "Do Better Next Time"

i need a big help on this...please!

I would like some help with a formula.

I have a spreadsheet which has columns with date ranges and an amount of hours worked during that date range. I then have other columns with different date ranges. These date ranges cross over with the date ranges of the first ones. I need to find out how much is earned in the second lot of date ranges from the other information.

It's hard to explain, but if you take a look at the attachment you will understand. Under the first lot of columnns you will see that there are week and fortnightly date ranges. Then total amount of hours worked in that period. I then have a column which works out the amount of working days during that period. I then have hours worked per day, hourly rate and a gross amount for that period. I then have a different set of date ranges. I need the formula to calculate the hours worked and gross amount earned in the second lot of date ranges based on the info from the first set of date ranges. For example: fortnight 22/1/12 - 4/2/12 the person worked 53 hours at $25 per hour.This equals a gross amount earned of $1325. And for the fortnight 5/2/12 - 18/2/12 the person worked 76 hours at $25 per hour. This equals a gross amount earned of $1900. Now, the other fortnight date range shows fortnight 24/1/12 - 6/2/12. Based on the info from the first columns I need to work out what the hours and gross earnings are for the period 24/1/12 - 6/2/12.

Thankyou for all your help

Column A (Starting Revenue)

Column B (Increase Revenue)

Column C (Reduce Revenue)

Column D (New Business)

I need a formula in Column F that would calculate the total commissions earned based on the following createria:

6% on Starting Revenue

3% on Reduce Revenue

12% on Increae Revenue

12% on New Business

N.B:

If there is a figure in Column A & C, then the formula should only calculate using Column A-Column C*3%.

If there is a figure in Column A & B, then the formula should be based on the values of on both columns (6% on Column A + 12% on Column B)

If there is a figure in only Column D, then the formula should be column D*12%

I have this formula in column E =(A1)*6% + (B1)*12% + (C1)*12% + (D1)*3%

With this formula it works well for everything except the Column C as it returning to values, that of Column C (3%) plus that of column A (6%). I need it to return on the 3%.

Please help.

Thank you in advance

Angus

It's that time of the year again. Get a jump on your holiday checklist by learning how to create (and send) your newsletter in Word.

I'm searching for a formula that would copy the appropriate price range for the specific age and "gender" in the receipt sheet in the workbook attached.

Suppose if the age is written in the cell "B2" and "gender" as either "Male or "Female" in the cell "E2" of how could the code be modified so that it copies the appropriate price range for the specific age and gender in the receipt sheet.

Note: if any figure between the age range is written in cell "B2".

I have attached the workbook for your reference.

Thanks in advance.

I use this program to work out my desks' commission at work every day. We have two desks, 930 and 941. The commissions they make go into the same spreadsheet, I currently bodge adding them up but was wondering if there was a sleek way of getting excel to create a total for the 930 commissions, and total for the 941 commissions? the desk number is a cell away from the commission for a trade, if that makes any sense or helps anyone? If this is impossible to understand please forgive me, I really don't sepak excel lol! If anyone could help, I'd really appreciate it

Thanks

Milly

Kind of confusing. Please see attached for an example

Thanks!

I need a formula that will scan column A (Code)total the like items (also) add column B (Qty) if there is a number greater than 1. Then add the price ($) together and divide by the sum of A&B.

In other words find the average price for the total of each item..

A B C

Code Qty $

PH06003000 1 1504.8

PH06003000 1 1582.24

PH06003000 1 1606

PH06003000 1 1504.8

PH06003000 2 3009.6

PH06003000 1 1504.8

PH06003000 1 1504.8

PH06003000 1 1504.8

PH06024000 1 2499.2

PH06024000 1 2499.2

PH06024000 1 1896.07

PH06024000 2 3909.66

PH06024000 1 2240.7

PH06024000 1 2259.4

PH06024000 15 30030

PH06024070 1 2039.4

PH06024070 1 1958.66

PH06025670 1 2521.2

Is there a formula that can do this..???

Regards

Paul

I was wondering you there is a simple formula that will return two values from a spreadsheet.

1. Look in the spreadsheet, count how many times that value is found.

and then

2. If this value is found, add up the total "QTY" that that value (in 1) has in the spreadsheet.

As in the case below - I need to find how many times "L" appears , then add up the total "Qty" for "L" - can this then be put in two cells (IE: (in this case) 2 4...??

A B C D

P PH070 12 2

L PH060 12 2

P SESTHPB045 30 4

L PB080 12 2

W PB060 12 2

Thankyou

at end of year i need to move the totals of each month to a yearly total

sheet...

when i highlite and copy the monthly total and paste to new sheet , i get

REF!

??? can u help me

I have attached a file. In our office we have an 8hr workday that's 8am-5pm. However, we have this what we call as flexitime wherein we can come to work late for up to 30mins that's up to 8:30 provided that we will go out 30mins late as wee that's up to 5:30.. We also have a 1hr (12nn-1pm) lunch break from which we can time in/out between 12NN-1PM.

My problem is: how to compute for the total number of work hours and minutes (this is in case the employee goes undertime or beyond flexitime)?

thanks!

work schedule: Monday to Friday 8:30am to 5:30pm

time in time out tardy under time

employee name: 08:45 AM 04:30 PM .15 1.00

Because of the work schedule I can't come up with the correct result.

Thanks in advance. any help will be appreciated.

30FPS

=TEXT(LEFT(B2,8)-LEFT(A2,8)-(RIGHT(A2,2)>RIGHT(B2,2))/86401,"m:ss")&TEXT(MOD(RIGHT(B2,2)-RIGHT(A2,2),30),":00")

24FPS

=TEXT(LEFT(B2,8)-LEFT(A2,8)-(RIGHT(A2,2)>RIGHT(B2,2))/86400,"m:ss")&TEXT(MOD(RIGHT(B2,2)-RIGHT(A2,2),24),":00")

notice the totalizer reset and started counting again.

(the actual total gallons for the day would be: 572.229 +24.317)

how do I create a formula to see only the highest number in each runtime for calculation (sum)

total gallons

24.317

24.317

24.317

15.303

0.580

572.229

554.862

126.832

113.046

95.847

81.529

65.807

49.757

33.871

20.030

1.775

0.000

0.000

I need to make a schedule of quarterly payments to our company. Is there any way that I could just input the start date and the end date and excel will compute for the rest of the payment dates?

For example: There are 20 payment dates for 5 years and the payment time is quarterly. Here are the dates that were manually inputted:

3/9/20076/11/20079/10/200712/10/20073/10/20086/9/20089/9/200812/9/20083/9/20096/9/20099/9/200912/9/20093/9/20106/9/20109/9/201012/9/20103/9/20116/9/20119/9/201112/9/20113/9/2012

Can excel compute automatically for the dates in between the start date and the end date? One condition is that the payment date should not fall on a weekend or a holiday. If it did fall on a weekend or holiday, then the payment date shall be the next business date. Another condition is that if the payment date falls on the 31st or 30th of the month and these days fall on a holiday or weekend, the payment date shall be move to the last business date of that month.

I have been trying to do some reading on the topics of dates and if conditions. I am not very good in excel so I am really having a hard time figuring out the solution to the problem. Do I need a database of the dates that would reflect holidays and weekends and then somehow link the data?

I hope you guys can help me. I would really appreciate it.

Thanks very much.

Code:

--------------------

Column A

Dept Units

Apparel 150

Apparel 142

Licensee 80

Footwear 64

Apparel 63

Footwear 62

Total Units

Apparel Formula

Licensee Formula

Footwear Formula

--------------------

I need a formula that will give me the total units for any dept labled

Apparel, Licensee, and Footwear. Every week the number of units will

change and I have to resort the list so the order is always different.

I'm thinking the best way to do it is for a formula to look for the

word Apparel and any time it finds it to add the units to a total.

Thanks in advance for any help.

--

Weasel

------------------------------------------------------------------------

Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206

View this thread: http://www.excelforum.com/showthread...hreadid=531917

3rd for the total. The following week, the current week column will become

the previous week. Meaning I will have to move the information over to the

2nd column and I will input new numbers into colum one for the "new current

amount". My problem is once I change the information in colum 1, the "total"

colum will also change. My problem is, I need this to be ongoing for the

entire month. Hope this make sense

What is the formula to look for similar word under KEY and get it to look

for the highest value and REV and retun the RESULT value?

Example below

KEY REV RESULT

a 0 1

b 0 5

c 0 2

b 1 6

c 1 3

b 2 4

want result to be...

a 0 1

b 2 4

c 1 3

* I have 7 columns with in order;

division, cartons, returned cartons, income, cartons, returned cartons, income

3 divisions (junior, senior and sjunior) are selling 2 types of chocolates,

* each row represents a player from the club

Senior 15 15 $30.00 15 15 $75.00

Senior 15 15 $30.00 15 15 $75.00

Senior 15 15 $30.00 15 15 $75.00

Senior 15 14 $28.00 15 12 $60.00

Senior 15 13 $26.00 15 13 $65.00

Senior 15 15 $30.00 15 14 $70.00

Senior 15 13 $26.00 15 15 $75.00

Senior 15 15 $30.00 15 15 $75.00

Junior 10 9 $18.00 10 9 $45.00

Junior 10 10 $20.00 10 10 $50.00

Senior 15 9 $18.00 15 14 $70.00

SJunior 5 5 $10.00 5 5 $25.00

SJunior 5 3 $6.00 5 5 $25.00

Junior 10 10 $20.00 10 13 $65.00

Senior 15 15 $30.00 15 14 $70.00

(income is the returned cartons * carton price @ $2 and $5)

what would the formula be for the total of each division

if the worksheet above is G2:J16

???

Column A Dept Units Apparel 150 Apparel 142 Licensee 80 Footwear 64 Apparel 63 Footwear 62 Total Units Apparel Formula Licensee Formula Footwear FormulaI need a formula that will give me the total units for any dept labled Apparel, Licensee, and Footwear. Every week the number of units will change and I have to resort the list so the order is always different. I'm thinking the best way to do it is for a formula to look for the word Apparel and any time it finds it to add the units to a total. Thanks in advance for any help.

a1

product name

b1

amount by each

c1

cost each

d1

code number

How do i compute for the number of hours that fall into the Night Differential hours within an employees shift? In one cell is the shift start time of an employee and on the other cell is the shift end time. There is no constant number of hours that an employee should complete. Night Differential time starts at 10:00 PM and ends at 6:00AM.

Thanks

In this excel sheet i have, in the D column there are cells with the following value "Oprettet dato" this is constant and randomly placed in the D column, but everytime this value appears in a cell, the cell below (row below if you will) has a random value like a date (14-04-2010). I need something that will search out and clear both cells for the entire sheet. And do the same search for the E column searching for "Stk på lager" and the cell below

No luck finding an answer? You could always try Google.