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