Giving value to a letter

[=!CmOrE!=]

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

 

[Guest]

Try:

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

 

[Guest]

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:

 

[=!CmOrE!=]

Thanks a bunch, that worked perfectly. Thank you

Try:

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

 

[Ragdyer]

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.

 

[=!CmOrE!=]

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]

My misunderstanding.

Thanks for the feed-back.