HELP! I KNOW U KNOW HOW TO DO THIS....
 

i was told there is a way to make certain letters equal numbers. EX.
BREADNMILK is 1234567890 / B=1 R=2 and so on. This is so each product has a
digit code for the price. EX. EDB = $3.51. I don't know how to do that but my
boss said it's possible....THANK-YOU!

I have an idea, but I'm not sure I understand what you really want, so I
hate to waste the time to produce it. Could you give a few more examples?
What are you doing with the data once you figure out a way to make this
work? Why BREADNMILK? Is that just an example? You'll use just one word?
You're trying to obscure the price? Like I said... it's not clear.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"laceyMKTSP" wrote in message
...
i was told there is a way to make certain letters equal numbers. EX.
BREADNMILK is 1234567890 / B=1 R=2 and so on. This is so each product has
a
digit code for the price. EX. EDB = $3.51. I don't know how to do that but
my
boss said it's possible....THANK-YOU!

i work for a company that uses BREADNMILK. i dont know why. B=1 R=2 E=3 and
so on. they need a chart that goes like this:
Letter Code = Price x Quantity = Total
Ex. EBR = $3.12 x 2 = 6.24

so i just need to know how to assign the 1 2 3 to B R E and etc. does that
make a little more sense?
--
thanks for your help


"laceyMKTSP" wrote:

i was told there is a way to make certain letters equal numbers. EX.
BREADNMILK is 1234567890 / B=1 R=2 and so on. This is so each product has a
digit code for the price. EX. EDB = $3.51. I don't know how to do that but my
boss said it's possible....THANK-YOU!

Lots of retail stores have different prices for employees.

Sometimes, they'll encode that price on the tag using a keyword like breadnmilk
to hide it from the regular customers.

Anne Troy wrote:

I have an idea, but I'm not sure I understand what you really want, so I
hate to waste the time to produce it. Could you give a few more examples?
What are you doing with the data once you figure out a way to make this
work? Why BREADNMILK? Is that just an example? You'll use just one word?
You're trying to obscure the price? Like I said... it's not clear.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

"laceyMKTSP" wrote in message
...
i was told there is a way to make certain letters equal numbers. EX.
BREADNMILK is 1234567890 / B=1 R=2 and so on. This is so each product has
a
digit code for the price. EX. EDB = $3.51. I don't know how to do that but
my
boss said it's possible....THANK-YOU!


--

Dave Peterson

Okay, Lacey. We hooked you up. I am not good with funky formulas, tho I'm
sure it could have been done. Download this file:
http://www.myexpertsonline.com/freedls/pricer.xls
Type any price into any cell on sheet1, and hit enter. It'll auto-change
into your code.
Compliments of "drj" from www.vbaexpress.com
:)

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"laceyMKTSP" wrote in message
...
i work for a company that uses BREADNMILK. i dont know why. B=1 R=2 E=3
and
so on. they need a chart that goes like this:
Letter Code = Price x Quantity = Total
Ex. EBR = $3.12 x 2 = 6.24

so i just need to know how to assign the 1 2 3 to B R E and etc. does that
make a little more sense?
--
thanks for your help


"laceyMKTSP" wrote:

i was told there is a way to make certain letters equal numbers. EX.
BREADNMILK is 1234567890 / B=1 R=2 and so on. This is so each product
has a
digit code for the price. EX. EDB = $3.51. I don't know how to do that
but my
boss said it's possible....THANK-YOU!

Assume your letter code is in A1

In D1:D10 put K R E A D N M I L K
and in E1:E10 put 0 1 2 3 4 5 6 7 8 9

In F1 put 2, in F2 put 3, etc etc to F5 put 6

in G1 put
=("."&VLOOKUP(LEFT($A$1,1),$D$1:$E$10,2,FALSE)&VLO OKUP(RIGHT($A$1,1),$D$1:$E
$10,2,FALSE))*1


In G2 put
=(VLOOKUP(LEFT($A$1,1),$D$1:$E$10,2,FALSE)&"."&VLO OKUP(MID($A$1,2,1),$D$1:$E
$10,2,FALSE)&VLOOKUP(RIGHT($A$1,1),$D$1:$E$10,2,FA LSE))*1


Carry on with this same idea for G3, G4, and G5 for codes with more than
three characters.


Then in B1 put =VLOOKUP(LEN(A1),F1:G5,2,FALSE) and format for currency.

Vaya con Dios,
Chuck, CABGx3



"laceyMKTSP" wrote in message
...
i was told there is a way to make certain letters equal numbers. EX.
BREADNMILK is 1234567890 / B=1 R=2 and so on. This is so each product has
a
digit code for the price. EX. EDB = $3.51. I don't know how to do that but
my
boss said it's possible....THANK-YOU!

Sorry,

Should have been...
In D1:D10 put K B R E A D N M I L
( Just move the K and 0 to the top of the list)

not
In D1:D10 put K R E A D N M I L K

it was too late last night for us old guys to be up I guess..........<G

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote in message
...
Assume your letter code is in A1

In D1:D10 put K R E A D N M I L K
and in E1:E10 put 0 1 2 3 4 5 6 7 8 9

In F1 put 2, in F2 put 3, etc etc to F5 put 6

in G1 put

=("."&VLOOKUP(LEFT($A$1,1),$D$1:$E$10,2,FALSE)&VLO OKUP(RIGHT($A$1,1),$D$1:$E
$10,2,FALSE))*1


In G2 put

=(VLOOKUP(LEFT($A$1,1),$D$1:$E$10,2,FALSE)&"."&VLO OKUP(MID($A$1,2,1),$D$1:$E
$10,2,FALSE)&VLOOKUP(RIGHT($A$1,1),$D$1:$E$10,2,FA LSE))*1


Carry on with this same idea for G3, G4, and G5 for codes with more than
three characters.


Then in B1 put =VLOOKUP(LEN(A1),F1:G5,2,FALSE) and format for currency.

Vaya con Dios,
Chuck, CABGx3



"laceyMKTSP" wrote in message
...
i was told there is a way to make certain letters equal numbers. EX.
BREADNMILK is 1234567890 / B=1 R=2 and so on. This is so each product
has
a
digit code for the price. EX. EDB = $3.51. I don't know how to do that
but
my
boss said it's possible....THANK-YOU!