View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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