nested if
 

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

nested if
 

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

If this post helps click Yes
---------------
Jacob Skaria


"I don't know Excel" wrote:

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

nested if
 

Try this:

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

--
Biff
Microsoft Excel MVP


"I don't know Excel" <I don't know wrote in
message ...
Need nested if for
if a1 = " " value of cell is blank
if a1=b1 value of cell is word good, if not equal "bad"

nested if
 

"I don't know Excel" <I don't know wrote:
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"))

nested if
 

=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?

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
Try
=IF(A1,IF(A1=B1,"Good","Bad"),"")

If this post helps click Yes
---------------
Jacob Skaria


"I don't know Excel" wrote:

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

nested if
 

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

Since the OP as mentioned A1 = " " it is better to TRIM()
if a1 = " " value of cell is blank

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


"T. Valko" wrote:

=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?

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
Try
=IF(A1,IF(A1=B1,"Good","Bad"),"")

If this post helps click Yes
---------------
Jacob Skaria


"I don't know Excel" wrote:

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