MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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]