+ Reply to Thread
Results 1 to 2 of 2

Need help with writing an IF statement

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Need help with writing an IF statement

    Hello,
    I am trying to write an IF statement that will do the following

    If column A's value is between 0-3499, show "0-3499"
    if it is between 3500-4999, show "3500-4999"
    If it is between 5000-7999, show "5000-7999"
    if it is between 8000-11999, show "8000-11999"
    if it is 12000 or higher, show "12000+"

    Can anyone help please?

    Thank you!

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Need help with writing an IF statement

    Try

    =LOOKUP(A1,{0,3500,5000,8000,12000},{"0-3499","3500-4999","5000-7999","8000-11999","12000+"})

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Writing an AND or OR statement
    By rcocalm in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-15-2013, 09:25 AM
  2. Help Writing IF Statement
    By sburque in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-12-2013, 01:56 PM
  3. [SOLVED] Writing an =if statement with contains
    By 1Monkey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-12-2012, 12:21 PM
  4. writing a statement
    By newexceluser in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-21-2006, 05:25 PM
  5. [SOLVED] Help writing an IF statement
    By cynichromantique in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-31-2006, 07:55 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