Check Box Question

K

Ksean

How do I achieve the following?

If cell D10 has anything of any value in it I would like cell D5 to display
a result of ‘X’ however if cell D10 is blank then I would like cell D5 to
remain blank.

The 'X' is actually be an 'X'

Thanks
 
K

Ksean

How would I adjust your formula to handle three different cells at the same
time?
i.e. D10 and/or G10 and/or J10.

That is to say if cell D10 and/or G10 and/or J10 have anything of any value
in either of them I would like cell D5 to display a result of 'X' however if
cell D10 and/or G10 and/or J10 are all blank then I would like cell D5 to
remain blank.

Thanks,
Ksean
 
T

T. Valko

Maybe this...

=IF(COUNTA(D10,G10,J10),"X","")

If any of those cells contain formulas that might return formula blanks ("")
the formula will "see" that and consider that to be something in the cell.
 
K

Ksean

Thanks, your formulas worked great!



T. Valko said:
Maybe this...

=IF(COUNTA(D10,G10,J10),"X","")

If any of those cells contain formulas that might return formula blanks ("")
the formula will "see" that and consider that to be something in the cell.

--
Biff
Microsoft Excel MVP





.
 

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

Top