Free Microsoft Excel 2013 Quick Reference

# Compute for the total commission and gross pay

formula: compute for total commission = total sales * commision
compute for the gross pay = net pay + total commission

## Related Results

### Determine the commission

if the commission is grater tha 100,000.00 commission is 15% else 10%
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!

### Formula to calculate the hours worked and gross amount earned

Hi,

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.

### Calculate the total commissions

Need help with setting the correct formula.

Column A (Starting Revenue)
Column B (Increase Revenue)
Column C (Reduce Revenue)

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

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%.

Angus

### Training: Prepare for the holidays: Write and send a newsletter with Word

Training: Prepare for the holidays: Write and send a newsletter with Word

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.

### Copy price range for the specific age and gender in the receipt sheet

Hi Anyone,

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.

### Create a total for commissions based on commission number

Heya, I'm a real noice with excel, so please bare with me!

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

### Gross pay Calculator

Trying to find a formula in G2 that takes the people's names in column A, vlookup or similar to find out how much he/she makes per hour, and calculates it with total work hours. Gross pay would take into account for all individuals together, and not separate.

Kind of confusing. Please see attached for an example

Thanks!

### Sum the total and find the average cost

Greetings,

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

### Returning the total number and the qty.

Greetings.

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

### IN EXCEL...I CANNOT COPY THE TOTAL LINE AND PASTE IT ...I GET REF.

I USE spreadsheets for monthly books...
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

### Computing the Hours Worked

Good Day!

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!

### Formula and computation for timesheet with workschedule

Am working on my time sheet. The problem is I can't compute for the tardiness and under time. Also I have to consider the working schedule in order to come up with the correct computation for it. sample below is the correct computation:

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.

### Formula for obtaining the total running time from the time code

I need to use a specific Excel template to input timecodes (cue-IN and cue-OUT) and get the duration for each set (cue-OUT minus cue-IN) as well as the grand total of all the duration (total running time). The formula for each row to figure out the duration is given but there is no formula provided to figure out the total running time. Could you kindly take a look at the attached sample file and provide me with the formula for the total duration (orange cell)? I would appreciate it very much. The following are the formulae for two different frame rate (frame per second).

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")

### calculating the total from a running totalizer that resets

a computer is entering data from a totalizer into an excel spreadsheet like below: (the entries begin at the botom)
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

### Help! Formulas for dates, excluding holidays and weekends

Hi,

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.

### Need a formula to add the total # each time it finds a name

Here's how my current sheet looks like:

Code:
--------------------

Column A

Dept Units
Apparel 150
Apparel 142
Footwear 64
Apparel 63
Footwear 62

Total Units
Apparel 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

### How to keep the total colum

I have 3 columns, 1 for the current amount, the 2nd for the previous and the
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

### Look for similar text and find the largest value and return value

Hello,
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

### Using an IF function for a total

ok, say I have a fundraising worksheet for a tennis club

* 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

???

### Need a formula to add the total # each time it finds a name

Here's how my current sheet looks like:

```Column A

Dept         Units
Apparel       150
Apparel       142
Footwear       64
Apparel        63
Footwear       62

Total           Units
Apparel        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.

### Number of product use for the day or week

hello i need help with a formula if possible example, i need to add on a different sheet, how many items of the same code where order for the day with the total amount and is possible to do the same thing for the week, can any one help im sure its something easy but im just having a hard time with this, Thank you .

a1
product name

b1
amount by each

c1
cost each

d1
code number

### Counting the days worked and days remaining on a schedule automatically

I've saw an excel spreadsheet that did this before; however, I have no idea where to start on this. I'm basically looking for a forumla that will count each employees total scheduled work days for the month inserted and then depening upon the day it is will show how many days the employee has left to work for the month.

### Computing for number of hours under Night Differential

Hi,

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

### Search and delete the result plus the cell below, and then loop

Hey guys/girls, I've only done vba's in the sence that recording the actions and copy & pasting them, do alot of .ahk scripting but never any real VBA. i've been giving a task at work and i need a script to help me out.

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