Thread: How can i make a name equal a value like DZ=12, GR=144 and EA=1?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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
Reply With QuoteReply With Quote