Check Box Question

  • Thread starter Thread starter Ksean
  • Start date Start date
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
 
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
 
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.
 
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





.
Click to expand...
 
Back
Top