+ Reply to Thread
Results 1 to 3 of 3

assigning a function (formula)

Hybrid View

  1. #1
    Registered User
    Join Date
    09-11-2007
    Posts
    2

    assigning a function (formula)

    I want to have a function assigned to a cell that gives the following result:

    If the value of cell B12 is 0 to 59, the result is ‘F’
    If the value of cell B12 is 60 to 69, the result is ‘D’
    If the value of cell B12 is 70 to 79, the result is ‘C’
    If the value of cell B12 is 80 to 89, the result is ‘B’
    If the value of cell B12 is 90-100, the result is ‘A’

    I am having trouble figuring out how to set this up. All feedback is appreciated.

    Thanks

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887
    Hi Scott,

    This formula should do what you're looking for:
    =LOOKUP(B12,{0,60,70,80,90;"F","D","C","B","A"})

  3. #3
    Registered User
    Join Date
    09-11-2007
    Posts
    2

    Thanks Paul

    Your formula worked perfectly. Thanks.

    Scott

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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