+ Reply to Thread
Results 1 to 2 of 2

Returning a numerical value from text

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    Chester, England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Returning a numerical value from text

    Hi all,

    I'm trying to streamline my spreadsheet a bit. Sometime last year I managed to use the formula found (on the attached file) in cell K4 to assign a numerical value to a lettered grade. However, it's been a year or so since I thought about it and so I've completely forgotten how to edit it to make it more appropriate for this spreadsheet!

    Essentially what I'm trying to do is a workaround for what I've already done in columns E and F: I'm trying to show the difference between two grades (letters) as a numerical value. Is there a way to do this, or is the VLOOKUP work around I've used in columns E and F going to be the simplest way?

    Thanks for your help!

    Matt
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Returning a numerical value from text

    As you already have a lookup table in the Grade Boundaries sheet, you could use that - put the numbers in column C and the VLOOKUP formula should use B and C as the table. You should have an entry for A* as well.

    Hope this helps.

    Pete

+ 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] Returning a Day from a numerical date formatt
    By CliveH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2013, 08:23 AM
  2. Replies: 3
    Last Post: 05-03-2012, 04:00 PM
  3. If statements: Non-numerical characters returning false when true
    By JONNY981 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-24-2009, 10:28 AM
  4. Text returning a numerical value
    By slinger1010 in forum Excel General
    Replies: 3
    Last Post: 11-14-2006, 08:24 AM
  5. [SOLVED] Round/Ceiling on an IF function returning numerical value or text
    By donnaK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-13-2005, 12:25 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