IF C2=X, THEN D2 is blank, AND E2 is blank
 

I am creating a spreadsheet where at the end of each row there will be 3
columns: YES/NO/NA. Is there a formula for if one is 'X'ed it will
automatically clear the other two columns if there were 'X'ed previously?

Or how do I correctly write:
IF C2=X, THEN D2 is blank, AND E2 is blank

Is it even possible?

Please help, Thanks!

IF C2=X, THEN D2 is blank, AND E2 is blank
 

A formula will affect only the cell in which it is written.
--
David Biddulph

"SLKoelker" wrote in message
...
I am creating a spreadsheet where at the end of each row there will be 3
columns: YES/NO/NA. Is there a formula for if one is 'X'ed it will
automatically clear the other two columns if there were 'X'ed previously?

Or how do I correctly write:
IF C2=X, THEN D2 is blank, AND E2 is blank

Is it even possible?

Please help, Thanks!

IF C2=X, THEN D2 is blank, AND E2 is blank
 

Is there some other way to make this happen? Conditional Formatting or
somthing. I can put the formula in each cell if I have to.
Thanks.

"David Biddulph" wrote:

A formula will affect only the cell in which it is written.
--
David Biddulph

"SLKoelker" wrote in message
...
I am creating a spreadsheet where at the end of each row there will be 3
columns: YES/NO/NA. Is there a formula for if one is 'X'ed it will
automatically clear the other two columns if there were 'X'ed previously?

Or how do I correctly write:
IF C2=X, THEN D2 is blank, AND E2 is blank

Is it even possible?

Please help, Thanks!

IF C2=X, THEN D2 is blank, AND E2 is blank
 

Conditional formatting can make the cell appear blank (by making the font
the same colour as the background), but of course the content is still
there.
--
David Biddulph

"SLKoelker" wrote in message
...
Is there some other way to make this happen? Conditional Formatting or
somthing. I can put the formula in each cell if I have to.

"David Biddulph" wrote:

A formula will affect only the cell in which it is written.

"SLKoelker" wrote in message
...
I am creating a spreadsheet where at the end of each row there will be 3
columns: YES/NO/NA. Is there a formula for if one is 'X'ed it will
automatically clear the other two columns if there were 'X'ed
previously?

Or how do I correctly write:
IF C2=X, THEN D2 is blank, AND E2 is blank

Is it even possible?

Please help, Thanks!

IF C2=X, THEN D2 is blank, AND E2 is blank
 

That's fine, could you tell me how to do it?

"David Biddulph" wrote:

Conditional formatting can make the cell appear blank (by making the font
the same colour as the background), but of course the content is still
there.
--
David Biddulph

"SLKoelker" wrote in message
...
Is there some other way to make this happen? Conditional Formatting or
somthing. I can put the formula in each cell if I have to.

"David Biddulph" wrote:

A formula will affect only the cell in which it is written.

"SLKoelker" wrote in message
...
I am creating a spreadsheet where at the end of each row there will be 3
columns: YES/NO/NA. Is there a formula for if one is 'X'ed it will
automatically clear the other two columns if there were 'X'ed
previously?

Or how do I correctly write:
IF C2=X, THEN D2 is blank, AND E2 is blank

Is it even possible?

Please help, Thanks!

IF C2=X, THEN D2 is blank, AND E2 is blank
 

Use "Formula is", rather than "Cell value is".
--
David Biddulph

"SLKoelker" wrote in message
...
That's fine, could you tell me how to do it?

"David Biddulph" wrote:

Conditional formatting can make the cell appear blank (by making the font
the same colour as the background), but of course the content is still
there.

"SLKoelker" wrote in message
...
Is there some other way to make this happen? Conditional Formatting or
somthing. I can put the formula in each cell if I have to.

"David Biddulph" wrote:

A formula will affect only the cell in which it is written.

"SLKoelker" wrote in message
...
I am creating a spreadsheet where at the end of each row there will
be 3
columns: YES/NO/NA. Is there a formula for if one is 'X'ed it will
automatically clear the other two columns if there were 'X'ed
previously?

Or how do I correctly write:
IF C2=X, THEN D2 is blank, AND E2 is blank

Is it even possible?

Please help, Thanks!