+ Reply to Thread
Results 1 to 2 of 2

Assigning a value to a letter

  1. #1
    Registered User
    Join Date
    10-13-2012
    Location
    Nutley,NJ
    MS-Off Ver
    Excel 2011
    Posts
    77

    Assigning a value to a letter

    This is a straight forward spreadsheet each number (color column) has a wt(white column) that it is associated with. There is a half time score, which is the addition of values between column B and I and a total score which is the a combination of values from B to Q

    But let's say in the White column I wanted to put the letter M and have it read M on the spreadsheet but keep a value of .5, how would I do that? Spreadsheet attached.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Assigning a value to a letter

    Just to clarify, are you saying that you may wish to enter the letter M in say cell M7 and any calculation involving M7 would use 0.5 as the value?

    Are there any other potential letter substitutions or will it only be M?
    If someone has helped you then please add to their Reputation

+ 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] Assigning a letter a value, then indicating whether there is a change
    By Kmartin83 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-29-2014, 11:57 AM
  2. Replies: 5
    Last Post: 08-21-2013, 09:31 AM
  3. Assigning a numerical value to a letter in excel
    By lisa07956 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2013, 09:45 AM
  4. Excel 2007 : assigning value to a letter
    By shockwave22 in forum Excel General
    Replies: 6
    Last Post: 02-24-2010, 04:56 PM
  5. Assigning a value to a letter.
    By Fuzzdawg in forum Excel General
    Replies: 4
    Last Post: 01-20-2010, 03:14 AM
  6. Assigning a value to a letter
    By snowbunny00774 in forum Excel General
    Replies: 2
    Last Post: 09-01-2006, 09:52 AM
  7. [SOLVED] Assigning a number value to a letter?
    By Orphan86 in forum Excel General
    Replies: 3
    Last Post: 08-30-2005, 07:05 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