Question about Business & Productivity Software

2 Answers

Excel formula Hello, I have an excel assignment that I am working on, and I am at an impass, I hoping that someone will be able to help me... I need to create a formula that calculates over time for anything over 40 hours. If the person has worked over 40hrs the formula will give you their overtime pay if they haven't the value will be 0. (C11+1.5*MAX(0,C11>40))*D11 (C11 hours worked D11 Hourly wage)this the formula that i have been trying to tweak for the last two hours, this formula gives me their regular rate of pay, which I do not require. Please help me.

Posted by on

  • Anonymous Dec 26, 2008

    Now I need to know how to added to the regular pay to the overtime formula to give me the total pay

  • Anonymous Dec 26, 2008

    how do you create a formula for wages earn by commision

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

HELLOW,

I have to calculate weekly overtime, anything over 48 hours, but the same time, if an approved leave is there, OT will be counted, similarly un approved leave , i.e. Absent, OT will not be counted.
I hve to calculate monday to saturday. 8 hours is the single working hours. Can anybody help me. sanjaydamodar@indiainfo.com

Posted on Apr 13, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Expert
  • 40 Answers

Hello,
The formula should go like this:
=IF(C11>40,(C11-40)*D11,0)
This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.
Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:
=IF(C11>40,(C11-40)*D11*1.5,0)

If you need more help, please ask.

Posted on Sep 15, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

What is the function of Microsoft excel?


Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

Excel 2003: Help with LOG formula


You've got some parenthesis in the wrong place. Try this:
=(86.01*(Log10(B2-B3)))-(70.041*(Log10(B4)))+36.76

Apr 06, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Formulas in computing grades in excel


www.youtube.com/watch?v=xOU_hL2_zBo

i havent watched it, but i think it might help. hope it helps, enjoy

Nov 16, 2008 | Microsoft EXCEL 2004 for Mac

3 Answers

Formulas in microsoft excel 2007


Excel 2007 has a rather elaborate formula pull down menu.it out,

Loringh

Nov 12, 2008 | Microsoft Excel for PC

4 Answers

I need Excel's Furmula's


I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Business & Productivity Software

1 Answer

Excel formula


I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.).

Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.

Now click back to Sheet1 where your data is and in A2 put this formula:
=VLookup(A1, Sheet2!$A$1:$B$x, 2, FALSE)
Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.

You can copy and paste this formula down the column to calculate your other values.

Hope that helps!
Terry

Aug 30, 2008 | Microsoft Excel for PC

4 Answers

How many formulas we can use at a time in Excel


That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

2 Answers

EXCEL ALL SHORT FORMULA


hiiiiiii
u know vlookup function,then piviot table
u know na tell short formula
genious...

Dec 14, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

695 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...