View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saxman Saxman is offline
external usenet poster
 
Posts: 111
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

Might this be possible with ISERROR?
--