can i make an X = 10 in excel?

[tatertatum]

I wish to use an X to =10 when ever i put it in a cell?
can this be done?

[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


"tatertatum" <tatertatum@discussions.microsoft.com> wrote in
message
news:2B5AEBF7-0D9A-4B81-990E-3AA2855C950D@microsoft.com...
>I wish to use an X to =10 when ever i put it in a cell?
> can this be done?

[Ardus Petus]

Menu Insert>Name>Define
name: X
Refers to: =10 (with the equal sign)

HTH
--
AP

"tatertatum" <tatertatum@discussions.microsoft.com> a écrit dans le message
de news: 2B5AEBF7-0D9A-4B81-990E-3AA2855C950D@microsoft.com...
>I wish to use an X to =10 when ever i put it in a cell?
> can this be done?

[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.

"Ardus Petus" wrote:

> Menu Insert>Name>Define
> name: X
> Refers to: =10 (with the equal sign)
>
> HTH
> --
> AP
>
> "tatertatum" <tatertatum@discussions.microsoft.com> a écrit dans le message
> de news: 2B5AEBF7-0D9A-4B81-990E-3AA2855C950D@microsoft.com...
> >I wish to use an X to =10 when ever i put it in a cell?
> > can this be done?
>
>
>

[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
--
AP

"tatertatum" <tatertatum@discussions.microsoft.com> a écrit dans le message
de news: 9FAE7E38-E1AA-43AE-991E-CA0DAC0DDE3D@microsoft.com...
>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.
>
> "Ardus Petus" wrote:
>
>> Menu Insert>Name>Define
>> name: X
>> Refers to: =10 (with the equal sign)
>>
>> HTH
>> --
>> AP
>>
>> "tatertatum" <tatertatum@discussions.microsoft.com> a écrit dans le
>> message
>> de news: 2B5AEBF7-0D9A-4B81-990E-3AA2855C950D@microsoft.com...
>> >I wish to use an X to =10 when ever i put it in a cell?
>> > can this be done?
>>
>>
>>