nested if

  • Thread starter Thread starter I don't know Excel
  • Start date Start date
I

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"
 
I don't know Excel said:
Need nested if for
if a1 = " " value of cell is blank
if a1=b1 value of cell is word good, if not equal "bad"
Click to expand...

=if(A1="", "", if(A1=B1, "good", "bad"))
 
=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?
 
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"))
 
Back
Top