If(And( Statement help.....

[Woozy39]

In PowerPivot I'm attempting to enter Woozy if the criteria of 2 columns meet the criteria....If the cell in column 1 is blank and the cell in column 2 is not blank...how do I do that?

=IF(AND([Column 1]="",[Column 2]="anytext"),"Woozy")

 

[BrianM]

Try:

=IF(AND(OR(A1="",ISBLANK(A1)),NOT(OR(B1="",ISBLANK(B1)))),"Woozy","What goes here")

 

[dalameda]

You can try:
=IF(AND([Column1]="",[Column2]<>""),"Woozy","")

 

[akice]

As calculated column:

= IF ( AND ( ISBLANK ( Table[Column 1] ), NOT ISBLANK (Table[Column 2] ) ), "Woozy" )