Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
how to get excel to display blank if reference cell blank | Excel Worksheet Functions |