writing a formula to distinguish a letter and a number
How do a write a forumla so that is the input is a letter, then look up
values in a table. If the input is a number, than just accept the number.
example:
Table:
a=1
b=2
c=3
Formula;
if input = a, then look up the value of a in a table, which is 1
if input =9, then just keep the input 9 as the result
|