IF on the cell that contains it ?
 

I actually don't know a lot about excel possibilities

I'm trying to make a "x" go through a line
something like
for A10 : =IF(A1=0,"x","")&IF(A10="x","","")
and so on for the following cases

I know this is not right but how could I make my x advance and see it
going in each case?

Thanks

We need more definition of what you mean by "making the x advance"
I can think of several possible meanings, with dramatically different
methods for solving he problem.


"miko" wrote:

I actually don't know a lot about excel possibilities

I'm trying to make a "x" go through a line
something like
for A10 : =IF(A1=0,"x","")&IF(A10="x","","")
and so on for the following cases

I know this is not right but how could I make my x advance and see it
going in each case?

Thanks

just meaning it appears in A20 (when A12=12 for exemple) and then goes
to B20, C20... with noone having to do anything... and stopping where I
want it to of course
thanks for responding

Do you want to have just one X at a time?

"miko" wrote:

just meaning it appears in A20 (when A12=12 for exemple) and then goes
to B20, C20... with noone having to do anything... and stopping where I
want it to of course
thanks for responding