How to convert (IF AND statement) to Custom - Data Validation

[love_guy_1977]

Hi,,

How can I convert (IF AND statement) to Custom - Data Validation.

My Example is:
=IF((AND(A1<>"",B1="")),,"XXX")

It is actually forcing C1 to accept value if A1 is not empty and B1 is empty


Thank you

 

[AlphaFrog]

Try something like this...
=AND(NOT(ISBLANK(A1)), ISBLANK(B1))

 

[love_guy_1977]

Try something like this...
=AND(NOT(ISBLANK(A1)), ISBLANK(B1))

Sorry it is not working.

How about convert it to vba usin [Private Sub Worksheet_Change(ByVal Target As Range)]?

 

[AlphaFrog]

Do A1 or B1 have formulas or do you type in value in those cells? It matters.

If they have formulas, then try this as the DV formula...
=AND(LEN(A1)>0, LEN(B1)=0)

Also, make sure you have "Ignore Blank" unchecked on the Data Validation dialog.

 

[love_guy_1977]

Do A1 or B1 have formulas or do you type in value in those cells? It matters.

If they have formulas, then try this as the DV formula...
=AND(LEN(A1)>0, LEN(B1)=0)

Also, make sure you have "Ignore Blank" unchecked on the Data Validation dialog.

Thank you,

=AND(NOT(ISBLANK(A1)), ISBLANK(B1))
is working with "Ignore Blank" unchecked

Thank you again