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

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

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

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

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

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

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