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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi

Define named ranges (Insert>Name>Define from menu)

DZ = 12
GR = 144
EA = 1

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


Arvi Laanemets
 
Back
Top