Saxman,

=CHOOSE(A2,11,8,7,0,0,0,0,0,0)

This won't handle 0 or above 9 or blank. So:

=IF(AND(A3=1,A3<=9),CHOOSE(A3,11,8,7,0,0,0,0,0,0) ,0)
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Saxman" wrote in message
...
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?
--