nested if

[I don't know Excel]

Need nested if for
if a1 = " " value of cell is blank
if a1=b1 value of cell is word good, if not equal "bad"

 

[Jacob Skaria]

Try
=IF(A1,IF(A1=B1,"Good","Bad"),"")

If this post helps click Yes

 

[T. Valko]

Try this:

=IF(A1="","",IF(A1=B1,"Good","Bad"))

 

[JoeU2004]

Need nested if for
if a1 = " " value of cell is blank
if a1=b1 value of cell is word good, if not equal "bad"

=if(A1="", "", if(A1=B1, "good", "bad"))

 

[T. Valko]

=IF(A1,IF(A1=B1,"Good","Bad"),"")

Are you sure you want to use that?

A1 = x
B1 = x

Why isn't the result Good?

 

[Jacob Skaria]

Yep..that will not work for text...Thanks.

Since the OP as mentioned A1 = " " it is better to TRIM()
=IF(TRIM(A1)="","",IF(A1=B1,"Good","Bad"))