+ Reply to Thread
Results 1 to 2 of 2

Help needed with IF function

Hybrid View

  1. 02-24-2015, 05:33 AM #1
    emers21
    emers21 is offline
    Registered User
    Join Date
    02-10-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    16

    Help needed with IF function

    Hi All,

    I am looking to create a score sheet for monitoring attained grades. I have been trying to come up with various ways of arranging the below information but I am struggling. I have tried various IF functions but I have yet to find the correct formula.

    Here is what I want to achieve

    In cell A1 I will insert a score. In B1 I want excel to automatically insert a designated word.

    If A1 is 0-10 I want B1 to say "Below"
    If A1 is 11 - 20 I want B1 to say "Towards"
    If A1 is 21 - 30 I want B1 to "At"
    If A1 is 31 - 40 I want B1 to say "Above"

    Can anyone help with this as I can't find a solution so far.

    Cheers
    Reply With QuoteRegister To Reply
  2. 02-24-2015, 05:42 AM #2
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Help needed with IF function

    hi emers. with IF would be a little more lengthy. try:
    =LOOKUP(A1,{0,11,21,31},{"Below","Towards","At","Above"})

    or just to show you how IFs would look like:
    =IF(A1<11,"Below",IF(A1<21,"Towards",IF(A1<31,"At","Above")))

    this is of course assuming no other numbers like negative or your unstated range above 40, which you would need AND
    =IF(AND(A1>=0,A1<11),"Below",.....

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."

    Tips & Tutorials I Compiled | How to Get Quick & Good Answers
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If Then Function Help needed
    By wheatgrass in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2012, 01:41 PM
  2. sum function help needed
    By novice2430 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-12-2008, 04:50 PM
  3. Function or VBA Help Needed
    By FireGeek822 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2005, 06:05 PM
  4. Help needed with sum function
    By Angela@Singh.com in forum Excel General
    Replies: 7
    Last Post: 08-24-2005, 08:05 PM
  5. function needed
    By David Harrison in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2005, 08:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1