Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Check Box Question

1 view
Skip to first unread message

Ksean

unread,
Jan 5, 2010, 1:16:02 PM1/5/10
to
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

unread,
Jan 5, 2010, 1:45:14 PM1/5/10
to
Try this entered in D5:

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

--
Biff
Microsoft Excel MVP


"Ksean" <Ks...@discussions.microsoft.com> wrote in message
news:F4DBEFA1-4AEF-41AF...@microsoft.com...

Ksean

unread,
Jan 5, 2010, 8:45:01 PM1/5/10
to
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:

> .
>

T. Valko

unread,
Jan 5, 2010, 10:06:02 PM1/5/10
to
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" <Ks...@discussions.microsoft.com> wrote in message

news:3E259B3D-474A-4925...@microsoft.com...

Ksean

unread,
Jan 7, 2010, 6:46:01 PM1/7/10
to
Thanks, your formulas worked great!

"T. Valko" wrote:

> .
>

T. Valko

unread,
Jan 7, 2010, 9:25:00 PM1/7/10
to
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Ksean" <Ks...@discussions.microsoft.com> wrote in message

news:4B520CFF-F523-4CBD...@microsoft.com...

0 new messages