Check Box Question

[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

 

[T. Valko]

Try this entered in D5:

=IF(D10="","","X")

 

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

 

[Ksean]

Thanks, your formulas worked great!

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





.

 

[T. Valko]

You're welcome. Thanks for the feedback!