I have a list in column A:
Apple
Banana
Cherries
Dates
I want column B to Give me a value of "1" for every Apple
I want column C to give me a value of "1" for every thing that is NOT an apple BUT not a value for Blank spaces
I can not get Column C to work. I can get it to work but get a value of "1" for blank spaces and everything that is not an apple.
This is what I have used- Open to any fix:
B2=IF(A2="Apples","1","0")
C2=IF(NOT(A2="Apples"), "1","0")
Apple
Banana
Cherries
Dates
I want column B to Give me a value of "1" for every Apple
I want column C to give me a value of "1" for every thing that is NOT an apple BUT not a value for Blank spaces
I can not get Column C to work. I can get it to work but get a value of "1" for blank spaces and everything that is not an apple.
This is what I have used- Open to any fix:
B2=IF(A2="Apples","1","0")
C2=IF(NOT(A2="Apples"), "1","0")