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.
Bookmarks