Results 1 to 13 of 13

Formula to make "word" equal "numeric value"

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2018
    Location
    Rio de Janeiro, Brasil
    MS-Off Ver
    2010
    Posts
    7

    Question Formula to make "word" equal "numeric value"

    Hello, I am very new to Excel, and had my Boss help me since he liked teaching basic things. He once helped me turn WORD into VALUE in two separate columns.

    I am trying to make "SUBWAY" equal "4.30"

    and "BUS" equal "3.90"

    what I want is the H4=G4+B4
    this would mean that subway(G4) + subway(B4) would = 8.60(H4)
    Being that on certain days it can vary from 2 subway or 1 subway and 1 bus.



    he used a very simple way without VLOOKUP or anything of that kind, from what i can remember it was something with a rule, not a formula, but i am open to any solution, His Rule was somehwere i cannot seem to find, but it was basically "WORD" = "VALUE"


    Pictures Below,

    Thanks for all the help, every comment is appreciated, i have searched not only this forum, but youtube, and google.

    Also hope i was able to explain myself without confusing everyone, my question might seem odd, but im still getting the hang of the short cuts and formulas.
    P.S. Im using Excel 2010, also I previewed the post and could not find a way to make the images smaller.

    UPDATE: I have tired Samba_ravi and Entregans solution, for some reason its giving me various errors, I have posted the file as PRODRIGUES,
    If anyone would care to try, because maybe I have done something wrong, thank you very much.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by PEDRO728; 10-03-2018 at 09:42 AM. Reason: adding document

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  4. [SOLVED] Cell Formula to count time with "Greater Than or Equal to" and "Less Than"
    By chriswhite1982 in forum Excel General
    Replies: 3
    Last Post: 06-16-2013, 12:30 AM
  5. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  6. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  7. If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM

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