Excel: Simple If (not) formula help

[COACHTEEJ]

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")

 

[mikerickson]

Try =COUNTA(A2)-B2

 

[Fluff]

Hi & welcome to MrExcel.
How about
=if(and(a2<>"",a2<>"Apples"),1,0)

 

[GraH]

Maybe like this?

Book1
	A	B	C
1		is Apple	Is NOT Apple, nor Blank
2	Apple	1	0
3	Banana	0	1
4	Cherries	0	1
5	Dates	0	1
6		0	0
7		0	0
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=(A2="Apple")*1
C2:C7	C2	=(AND(A2<>"Apple",TRIM(A2)<>""))*1

 

[COACHTEEJ]

Hi & welcome to MrExcel.
How about
=if(and(a2<>"",a2<>"Apples"),1,0)

Thank you- This worked like a Gem

 

[Fluff]

Glad we could help & thanks for the feedback.