How do I assign X = the value of 1 in a cell in Excell 2003?

[Guest]

How do I assign X = the value of 1 in a cell in Excell 2003?

 

[Bernard Liengme]

That need some explaining. Excel genially goes use variables but rather uses
cell references. Cells can be given names (such as x) but it is not
required.
Tell use more about what you wish to accomplish

best wishes

 

[Bernie Deitrick]

Put a 1 into any cell - let's say A1 -, and where you want to use X in a
formula, use the cell Address A1.

=X*100

becomes

=A1*100

HTH,
Bernie
MS Excel MVP

 

[Guest]

Thank you, but I want to put X in a cell and have X show in the cell, but
assign the numerical value of 1 to it.

 

[Guest]

I want to put X in a cell and have it show as X, but assign the value of 1 to
it, so that I can use a sum formula to count all of the x's as 1's.

 

[Bernie Deitrick]

No need to do that. If you just want to count the X's, use

=COUNTIF(A1:A100, "X")

It's almost always better to explain what you want to do in a global sense
rather than explain in a very narrow sense.

HTH,
Bernie
MS Excel MVP

 

[Guest]

Thank you that works. What classes can I take to learn more about formula's
and Functions?

 

[Bernie Deitrick]

A book would be better: I like John Walkenbach's books, so you could try

http://www.j-walk.com/ss/books/xlbook24.htm

HTH,
Bernie
MS Excel MVP