Results 1 to 8 of 8

I require help with an IF OR Formula

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2018
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    3

    I require help with an IF OR Formula

    So basically I am creating a spreadsheet for a budget. I need help creating a formula.

    if H5:H7 is less than 2000 then K6 = 300
    but if H5:H7 is greater than 2000 but less than 4000, k7 needs to = 600.
    and if H5:H7 greater than 4000 then k7 needs to equal 900.

    how would this formula be input?
    Last edited by DJAMESRUSHLOW; 07-22-2018 at 05:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 06-15-2016, 06:59 PM
  2. Require a formula
    By dicottrell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2015, 11:35 AM
  3. Excel 2013 Formula help required.
    By jamiehartle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-06-2014, 07:56 AM
  4. Require information on how a specific formula works (see inside for formula)
    By twiggywales in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-04-2012, 10:13 AM
  5. [SOLVED] Require Help - Require Formula for Multiple values in both columns
    By krodge in forum Excel General
    Replies: 6
    Last Post: 01-13-2012, 03:42 AM
  6. Require Formula
    By rasik in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2005, 06:41 AM

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