ExcelBanter - How do I set up having a letter = a value?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I set up having a letter = a value? (https://www.excelbanter.com/excel-discussion-misc-queries/10802-re-how-do-i-set-up-having-letter-%3D-value.html)

Peo Sjoblom

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.

All times are GMT +1. The time now is 11:58 PM.