formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top