IF on the cell that contains it ?

  • Thread starter Thread starter miko
  • Start date Start date
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical formatting for multiple values 1
Function for summing or counting cells based on a specified fill color 2
Conditional Formulas for Changing Cell Color 2
Counting cells only if cell X equals "yes" 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Countif contains a word in a reference cell 3
If any specific #s are present in range, show each in another cell 6
Variable Cell Range Reference 3

Back
Top