Giving value to a letter
 

Hello All,

I'm using Excel 2003. I would like to create a formula in which X=7.5
I would like to be able to write the following formula: =IF(B6=X,7.5,0)

If I place an X in the cell then the value of that cell is 7.5 I hope
I explain this correctly

Thank you in advance

Giving value to a letter
 

Try:

=IF(B6="X",7.5,0)

"=!CmOrE!=" wrote:

Hello All,

I'm using Excel 2003. I would like to create a formula in which X=7.5
I would like to be able to write the following formula: =IF(B6=X,7.5,0)

If I place an X in the cell then the value of that cell is 7.5 I hope
I explain this correctly

Thank you in advance

Giving value to a letter
 

hi, try to use auto correction

BUT, when you type x, when you type words text for eg. excel will return
"te7.5t"

hth
regards from Brazil
Marcelo

"=!CmOrE!=" escreveu:

Hello All,

I'm using Excel 2003. I would like to create a formula in which X=7.5
I would like to be able to write the following formula: =IF(B6=X,7.5,0)

If I place an X in the cell then the value of that cell is 7.5 I hope
I explain this correctly

Thank you in advance

Giving value to a letter
 

Thanks a bunch, that worked perfectly. Thank you
lk wrote:
Try:

=IF(B6="X",7.5,0)

"=!CmOrE!=" wrote:

Hello All,

I'm using Excel 2003. I would like to create a formula in which X=7.5
I would like to be able to write the following formula: =IF(B6=X,7.5,0)

If I place an X in the cell then the value of that cell is 7.5 I hope
I explain this correctly

Thank you in advance

Giving value to a letter
 

I don't quite understand what you're looking for.

If you want to assign a value to text, you could do this:

<Insert <Name <Define
In the "Names In WorkBook" box, type
X
Then, in the "Refers To" box, change whatever's there to
=7.5

Then <OK

NOW, in any cell, type
=X
And you'll get 7.5

Used in a formula,
=100+x
Will return 107.5

You can use X the same way you can use the number 7.5.

Your formula though,
=IF(B6=X,7.5,0)
Will return 0 if B6 contains an X,
BUT
If B6 contains 7.5,
It will return 7.5
So I don't really know if this is what you're looking for.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"=!CmOrE!=" wrote in message
ups.com...
Hello All,

I'm using Excel 2003. I would like to create a formula in which X=7.5
I would like to be able to write the following formula: =IF(B6=X,7.5,0)

If I place an X in the cell then the value of that cell is 7.5 I hope
I explain this correctly

Thank you in advance

Giving value to a letter
 

Actually, the formula =IF(B6="x",7.5,0) worked. I was trying to be
able to type X in a cell so that the cell value is 7.5 I was able to
accomplish that with the formula mentioned above. If B6="x" then enter
7.5 otherwise enter 0

Thank you

Ragdyer wrote:
I don't quite understand what you're looking for.

If you want to assign a value to text, you could do this:

<Insert <Name <Define
In the "Names In WorkBook" box, type
X
Then, in the "Refers To" box, change whatever's there to
=7.5

Then <OK

NOW, in any cell, type
=X
And you'll get 7.5

Used in a formula,
=100+x
Will return 107.5

You can use X the same way you can use the number 7.5.

Your formula though,
=IF(B6=X,7.5,0)
Will return 0 if B6 contains an X,
BUT
If B6 contains 7.5,
It will return 7.5
So I don't really know if this is what you're looking for.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"=!CmOrE!=" wrote in message
ups.com...
Hello All,

I'm using Excel 2003. I would like to create a formula in which X=7.5
I would like to be able to write the following formula: =IF(B6=X,7.5,0)

If I place an X in the cell then the value of that cell is 7.5 I hope
I explain this correctly

Thank you in advance

Giving value to a letter
 

My misunderstanding.

Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"=!CmOrE!=" wrote in message
oups.com...
Actually, the formula =IF(B6="x",7.5,0) worked. I was trying to be
able to type X in a cell so that the cell value is 7.5 I was able to
accomplish that with the formula mentioned above. If B6="x" then enter
7.5 otherwise enter 0

Thank you

Ragdyer wrote:
I don't quite understand what you're looking for.

If you want to assign a value to text, you could do this:

<Insert <Name <Define
In the "Names In WorkBook" box, type
X
Then, in the "Refers To" box, change whatever's there to
=7.5

Then <OK

NOW, in any cell, type
=X
And you'll get 7.5

Used in a formula,
=100+x
Will return 107.5

You can use X the same way you can use the number 7.5.

Your formula though,
=IF(B6=X,7.5,0)
Will return 0 if B6 contains an X,
BUT
If B6 contains 7.5,
It will return 7.5
So I don't really know if this is what you're looking for.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"=!CmOrE!=" wrote in message
ups.com...
Hello All,

I'm using Excel 2003. I would like to create a formula in which X=7.5
I would like to be able to write the following formula: =IF(B6=X,7.5,0)

If I place an X in the cell then the value of that cell is 7.5 I hope
I explain this correctly

Thank you in advance