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
|