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!!

In cell A25, enter:

=IF(A2=1,0,"")
--
Gary''s Student - gsnu200753


"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!!

Put this formula in A25:

=IF(A2=1,0,"")

You didn't say what you wanted if A1 is not 1 - this formula returns a
blank cell.

Hope this helps.

Pete

On Nov 5, 7:53 pm, 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!!

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!!