View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
=!CmOrE!= =!CmOrE!= is offline
external usenet poster
 
Posts: 7
Default 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