software

Hi all,
I have a list of prices, and I would like to convert them into code.
*BLACK HORSE:* B=1 L=2 and so forth. I only need even dollar amounts,
no cents. Someone gave me this formula, but it is for dollars and
cents, and it makes 0=B instead of 1=B. This is what I am working with
so far. Q is just a dummy letter in front of each code.

=quot;Qquot;amp;IF(ISNUMBER(A1),MID($G$1,A1/1000 1,1)amp;MID($G$1,MOD(A1,1000)/100 1,1)amp;MID($G$1,MOD(A1,100)/10 1,1)amp;MID($G$1,MOD(A1,10) 1,1)amp;MID($G$1,(A1-INT(A1))*10 1,1)amp;MID($G$1,ROUND((A1*10-INT(A1*10)),0)*10 1,1),quot;quot;)
Your help would be greatly appreciated.
Thanks again,
Nathan Sargeant--
natei6
------------------------------------------------------------------------
natei6's Profile: www.excelforum.com/member.php...foamp;userid=7185
View this thread: www.excelforum.com/showthread...hreadid=518949Hi Nate

Excel is calculating on a 0 - 9 sequence, while you want a 1 - 0 sequence.
The easiest way of solving the problem is to comply, and in stead of using
*BLACKHORSE:*, rather use *:BLACKHORSE*. You will then get the desired
effect.
hth

quot;natei6quot; wrote:

gt;
gt; Hi all,
gt; I have a list of prices, and I would like to convert them into code.
gt; *BLACK HORSE:* B=1 L=2 and so forth. I only need even dollar amounts,
gt; no cents. Someone gave me this formula, but it is for dollars and
gt; cents, and it makes 0=B instead of 1=B. This is what I am working with
gt; so far. Q is just a dummy letter in front of each code.
gt;
gt; =quot;Qquot;amp;IF(ISNUMBER(A1),MID($G$1,A1/1000 1,1)amp;MID($G$1,MOD(A1,1000)/100 1,1)amp;MID($G$1,MOD(A1,100)/10 1,1)amp;MID($G$1,MOD(A1,10) 1,1)amp;MID($G$1,(A1-INT(A1))*10 1,1)amp;MID($G$1,ROUND((A1*10-INT(A1*10)),0)*10 1,1),quot;quot;)
gt;
gt;
gt;
gt; Your help would be greatly appreciated.
gt; Thanks again,
gt; Nathan Sargeant
gt;
gt;
gt; --
gt; natei6
gt; ------------------------------------------------------------------------
gt; natei6's Profile: www.excelforum.com/member.php...foamp;userid=7185
gt; View this thread: www.excelforum.com/showthread...hreadid=518949
gt;
gt;