| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| Sort by number not by letter (C1, A2, B3, D4) | Excel Discussion (Misc queries) | |||
| linking a cell with a specific letter value to a cell with a formu | Excel Worksheet Functions | |||
| Giving a letter a numerical value | Excel Discussion (Misc queries) | |||
Threaded Mode
