IF on the cell that contains it ?

M

miko

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
 
B

bj

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.
 
M

miko

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
 
Top