T
tatertatum
I wish to use an X to =10 when ever i put it in a cell?
can this be done?
can this be done?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
I'm not sure what you mean, but you could insert a defined name
(CTRL+F3) named X which refers to the number 10. Then, use X in
your formulas:
=X+1
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
news:[email protected]...
(CTRL+F3) named X which refers to the number 10. Then, use X in
your formulas:
=X+1
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
news:[email protected]...
A
Ardus Petus
Menu Insert>Name>Define
name: X
Refers to: =10 (with the equal sign)
HTH
name: X
Refers to: =10 (with the equal sign)
HTH
T
tatertatum
I am looking to place x in a cell and if any formula pulls from that cell it
will give me a value of 10.
will give me a value of 10.
A
Ardus Petus
Enter "=A1*X" (without the quotes) to get the contents of A1 multiplied by
10
You can use X anywhere in your formulae.
HTH
10
You can use X anywhere in your formulae.
HTH