| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I set up having a letter = a value?
=IF(E1="a",formula1,IF(E1="b",formula2,""))
Regards, Peo Sjoblom "kfoix" wrote: I want to know if there is a way to type a letter in a column and make it represent a value. For example. If I type the letter b in column e1 I want it to represent a formula in c1. I am setting up a spreadsheet for my co workers to use and want it to be user freindly so they can type either a or b in a column and have it calculate the correct formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capitilize first letter | Excel Worksheet Functions | |||
| Replace Letter "E" with Letter "C" for 200 Different Sums in a Col | Excel Worksheet Functions | |||
| Capitalize first letter when type a name in each cell. | Excel Worksheet Functions | |||
| Letter format | Excel Discussion (Misc queries) | |||
| Function / formula to be used if cell contains a letter. | Excel Worksheet Functions | |||
Hybrid Mode
