How can i make a name equal a value like DZ=12, GR=144 and EA=1?
 

I'm trying to get a cell to know what his value is by putting a name. What I
really want it to do is to know if it is a Dozen by putting DZ so it will
automatically know it's 12. The same with a Gross, which is 144 and Each,
that's 1.
DZ = 12
GR = 144
EA = 1

How can i make a name equal a value like DZ=12, GR=144 and EA=1?
 

Use two cells. put the text in A1 and in B1:

=IF((A1="EA"),1,IF(A1="GR",144,12))

--
Gary''s Student - gsnu200739


"MariSwan" wrote:

I'm trying to get a cell to know what his value is by putting a name. What I
really want it to do is to know if it is a Dozen by putting DZ so it will
automatically know it's 12. The same with a Gross, which is 144 and Each,
that's 1.
DZ = 12
GR = 144
EA = 1

How can i make a name equal a value like DZ=12, GR=144 and EA=1?
 

Hi

Define named ranges (InsertNameDefine from menu)

DZ = 12
GR = 144
EA = 1

Now, p.e. the formula
=GR/DZ+EA
returns 13


Arvi Laanemets


"MariSwan" wrote in message
...
I'm trying to get a cell to know what his value is by putting a name. What
I
really want it to do is to know if it is a Dozen by putting DZ so it will
automatically know it's 12. The same with a Gross, which is 144 and Each,
that's 1.
DZ = 12
GR = 144
EA = 1