1. eran says's Avatar
    Hello. I am trying to find a way to have excel assign a numerical value to a word. I have a column in which I will either be entering a client's rate per session, or their insurance company. I would like to be able to tell excel that if I type in "BlueShield", that holds a value of 75 dollars.

    At the bottom of the column I would like to have excel add up the values for a total. Is there any way to do this?
    01-07-2016 03:08 AM
  2. Chintan Gohel's Avatar
    Hello. I am trying to find a way to have excel assign a numerical value to a word. I have a column in which I will either be entering a client's rate per session, or their insurance company. I would like to be able to tell excel that if I type in "BlueShield", that holds a value of 75 dollars.

    At the bottom of the column I would like to have excel add up the values for a total. Is there any way to do this?
    Using if functions maybe?

    For example: =IF(A2="blue",76)+IF(A2="g",40)
    I've kept the entries in column A and the values in column B
    So if I enter Blue, the corresponding value is 76.

    this could be taxing if you have a lot of values
    01-07-2016 03:57 AM
  3. eran says's Avatar
    Using if functions maybe?

    For example: =IF(A2="blue",76)+IF(A2="g",40)
    I've kept the entries in column A and the values in column B
    So if I enter Blue, the corresponding value is 76.

    this could be taxing if you have a lot of values
    Thanks for the reply, I was hoping to avoid another column. Is there any way I can do that?
    01-07-2016 12:07 PM

Similar Threads

  1. Nokia Lumia 635 Not Getting Notifications (Please Help!)
    By Will Antici1 in forum Ask a Question
    Replies: 1
    Last Post: 01-07-2016, 05:52 AM
  2. Replies: 0
    Last Post: 01-06-2016, 09:34 PM
  3. Can any one help me with my nextbook flexx 9 tablet?
    By Windows Central Question in forum Ask a Question
    Replies: 0
    Last Post: 01-06-2016, 09:18 PM
  4. Hi! I am about to give up and return this computer..help please!
    By Windows Central Question in forum Ask a Question
    Replies: 1
    Last Post: 01-06-2016, 06:14 PM
  5. Can you Guys/ Gals help me live Fix, Repair, MS Edge-Not working, it wont open?
    By Windows Central Question in forum Ask a Question
    Replies: 1
    Last Post: 01-06-2016, 04:53 PM
LINK TO POST COPIED TO CLIPBOARD