Number Transformation
By entering a numerical value in a cell A1, I would like to see another value
displayed in cell B1.
For instance, a 1 in A1 would display 11 in B1.
1 = 11
2 = 8
3 = 7
Else = 0 set below.
4 = 0
5 = 0
6 = 0
7 = 0
8 = 0
9 = 0
0 = 0
Might this be possible with ISERROR?
--
|