How do I create a formula to move data to a different cell
 

I am trying to create a elimination ladder and want to ceate a formula to
move names from one cell to another when an X is placed in a certain cell.
Example when cell C2 is checked as X name in C1 moves to F1

How do I create a formula to move data to a different cell
 

Formulae return values to their calling cells - they can't change other
cells. Assuming C1 and D1 have the two names and the X will go in C2 or
D2:

=IF(C2="X",C2,IF(D2="X",D2,"")

In article ,
Leland wrote:

I am trying to create a elimination ladder and want to ceate a formula to
move names from one cell to another when an X is placed in a certain cell.
Example when cell C2 is checked as X name in C1 moves to F1

How do I create a formula to move data to a different cell
 

in C1
=if(c2="X","","Name in C1")

in F1

=if(c2="X",C1,"")

--
Regards,
Tom Ogilvy


"Leland" wrote in message
...
I am trying to create a elimination ladder and want to ceate a formula to
move names from one cell to another when an X is placed in a certain cell.
Example when cell C2 is checked as X name in C1 moves to F1