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
Put this in B1...
=IF(A1=1,11,IF(A1=2,8,IF(A1=3,7,0)))
and copy it down.
Rick
|