Easily done as others have shown if 1 is your only choice in A2.

For more choices enter this in A25

=LOOKUP(A2,{1,2,3,4,5,6,7},{0,9,8,7,6,5,4})

Adjust numbers to suit


Gord Dibben MS Excel MVP

On Mon, 5 Nov 2007 11:53:00 -0800, bhssc
wrote:

I'm trying to figure out the formula so when I put a particular number in one
cell, the other cell will automatically be designated another number. For
example, if I were to put a 1 in cell a2, cell a25 will automatically enter
a 0 for that field. Any help with this would be great!!