How to make a symbol equate to a value
Posted by Mr. Darcy Guineay on January 18, 2002 10:24 PM
How do I make a symbol, such as ----- equal to 1, --X-- equal to 2, ----X equal to 3, etc.?
I need to put these symbols in cells and find a total of all the different cell filled symbols in the column at the end.
Posted by Juan Pablo G. on January 19, 2002 9:49 AM
If you can change '-' to '_' then you can have Named constants. Go to Insert, Name, Define.
In the first box type
_____
and in the refers to put 1
click Add.
Again, in the first box type
__X__
and in the refres to put 2
Click Add again.
and so on.
Now, in the sheet you can have this:
=_____*2
to return 2
Juan Pablo G.
Posted by Aladin Akyurek on January 19, 2002 1:52 PM
A fine proposal. [NT]
Posted by Mr. Darcy Guineay on January 19, 2002 8:00 PM
Re: A fine proposal. [NT]
Posted by Mr. Darcy Guineay on January 19, 2002 9:11 PM
Tried it but....
I did what you suggested but I guess I didn't explain it properly. I needed to have it show the symbol but when I add it up it will still calculate as if it were numbers.
Example:
A1 B1 C1 D1
__X___ + X_____ + _____ = =sum(A1:C1) answer 6
(1) (2) (3)
Symbols need to be shown in the cells.
Posted by Aladin Akyurek on January 20, 2002 12:41 PM
See: 16517.html [NT]
