| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| How to make a X amount equal $300,000 | Excel Discussion (Misc queries) | |||
| how can i make a letter equal 1? | Excel Discussion (Misc queries) | |||
| I want to make all of j equal h plus i. | Excel Worksheet Functions | |||
| How do I make one cell equal to another | Excel Worksheet Functions | |||
Hybrid Mode
