Results 1 to 10 of 10

Calculation formula greater than less than

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Calculation formula greater than less than

    Hi Experts,
    I'm looking formula in D column to calculate according the criteria, Example:

    In this example I need Cell D2 to be:
    -up to the first 40 hours is $10.00 per hour in this example -anything over 40 hours (7 in this example) is paid 1.5 times the hourly pay of $10
    -So the total for cell D2 needs to be: (40*10)+(7*15)=505


    I want the same formula for cell D2 that will work in D3 as well where there is no amount over 40 hours. So D3 will be (36*11)+(0*16.5)=396

    Thanks in Advance.
    gul
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculation if greater than 8
    By AaruJaan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-02-2019, 04:14 PM
  2. Replies: 1
    Last Post: 04-02-2016, 04:32 AM
  3. Replies: 4
    Last Post: 01-10-2014, 09:32 AM
  4. Replies: 5
    Last Post: 04-02-2013, 02:25 PM
  5. Replies: 3
    Last Post: 07-11-2012, 11:00 AM
  6. Replies: 2
    Last Post: 01-17-2012, 09:17 AM
  7. [SOLVED] Reversing POWER Formula:with greater algebra skills help me with below formula?
    By soroosj@swbell.net in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-01-2005, 07:05 PM

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