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


.



.