How to fix IF and AND statement

[Sean15]

Hello:

The formula below is returning "OK" for empty cells in column B and column D. I assume it's because Excel recognizes empty cells as zero.
How can formula be corrected to return "" for empty cells in column B and D? Thank you for your help.

IF(AND(B3<=55,D3<=11),"OK", "No")

Regards,
Sean

 

[Scott Huish]

=IF(COUNT(B3,D3)=2,IF(AND(B3<=55,D3<=11),"OK", "No"),"")

 

[Joe4]

=IF(AND(B3="",D3=""),"",[COLOR=#333333]IF(AND(B3<=55,D3<=11),"OK", "No"))[/COLOR]

 

[Sean15]

Thank you very much.
@Scott Huish - could you explain how IF(COUNT(B3,D3)=2 works.

Regards,
Sean

 

[Joe4]

It is just counting the number of entries in those two cells and see if it is equal to 2.
See here: https://support.office.com/en-us/article/COUNT-function-a59cd7fc-b623-4d93-87a4-d23bf411294c

 

[Scott Huish]

Yes, it's checking to see that there are 2 numbers in those cells.