Results 1 to 8 of 8

If statement to bring back great or less and apply rates

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2022
    Location
    Birmingham
    MS-Off Ver
    2016
    Posts
    5

    If statement to bring back great or less and apply rates

    Hi, I have a column hours and rates. Under the sum column im trying to do an if statement to bring back the following - If =IF(B2<37.5,"*D2,"2",)if(B2<37.5,"*D2,"1.5",)

    If its less than 37.5 hours x the rate column 1.5 and if its less than 37.5 x the rate column by 2. At the moment it bring back value.

    Please could I have help with my formula and guidance to where im going wrong?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 06-22-2020, 02:25 PM
  2. Apply Slab Rates????
    By ndmalam in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-10-2020, 09:37 AM
  3. vlookup - bring back blank cell when it brings back 0 and N/A
    By julee.stein in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2018, 11:12 AM
  4. [SOLVED] How to Bring back the Value of the top of the column
    By Diego Santos in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-20-2015, 10:33 AM
  5. Array Formula Lookup - Bring back Lowest Date + Bring Back Cell Location
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2014, 12:08 PM
  6. [SOLVED] Stop Vlookup bringing back 0's or #REF! and bring back blanks instead
    By Carling73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:43 PM
  7. Working out a price when different rates apply?
    By jason7579 in forum Excel General
    Replies: 3
    Last Post: 02-04-2010, 07:01 PM

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