Remember Me?

#1
May 23rd 05, 07:36 PM
 otto Posts: n/a
convert text to a value to be used in a formula

I need to identify specific text (letters) with a number and then be allowed
to use that number to calculate a formula. ie - "D" in a cell would be equal
to 10, "E" would be equal to 14, "D/E" would be equal to 24, etc.. I then
wish to add a string of cells that have been converted as above, to equate a
value. ie - 2 "D"s + 1 "E" = 1 "D/E" would calculatte to equal - 68

#2
May 23rd 05, 07:40 PM
 Vasant Nanavati Posts: n/a

Sorry, but this makes no sense to me. Could you elaborate?

--

Vasant

"otto" wrote in message
...
I need to identify specific text (letters) with a number and then be

allowed
to use that number to calculate a formula. ie - "D" in a cell would be

equal
to 10, "E" would be equal to 14, "D/E" would be equal to 24, etc.. I then
wish to add a string of cells that have been converted as above, to equate

a
value. ie - 2 "D"s + 1 "E" = 1 "D/E" would calculatte to equal - 68

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Dave Excel Discussion (Misc queries) 2 March 17th 05 03:14 PM c_prenderville Excel Worksheet Functions 2 March 15th 05 01:36 PM Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM DFM Excel Discussion (Misc queries) 5 December 27th 04 02:45 PM LZC Excel Worksheet Functions 3 November 27th 04 09:10 PM

All times are GMT +1. The time now is 05:11 PM.

The comments are property of their posters.