Check Box Question
 

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

Check Box Question
 

Try this entered in D5:

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

--
Biff
Microsoft Excel MVP


"Ksean" wrote in message
...
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

Check Box Question
 

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" wrote:

Try this entered in D5:

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

--
Biff
Microsoft Excel MVP


"Ksean" wrote in message
...
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


.

Check Box Question
 

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


"Ksean" wrote in message
...
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" wrote:

Try this entered in D5:

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

--
Biff
Microsoft Excel MVP


"Ksean" wrote in message
...
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


.

Check Box Question
 

Thanks, your formulas worked great!



"T. Valko" wrote:

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


"Ksean" wrote in message
...
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" wrote:

Try this entered in D5:

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

--
Biff
Microsoft Excel MVP


"Ksean" wrote in message
...
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


.



.

Check Box Question
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Ksean" wrote in message
...
Thanks, your formulas worked great!



"T. Valko" wrote:

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


"Ksean" wrote in message
...
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" wrote:

Try this entered in D5:

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

--
Biff
Microsoft Excel MVP


"Ksean" wrote in message
...
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


.



.