Formula to ignore if two cells are blank

[rossshah]

Hello,  I am looking for a formula on cell c2 to c6.  I have written if else formula to say Ok or Not Ok.  However, I want C5 to ignore the if else formula because A5 and B5 are blanks.   Right now, without the formula, it says not Ok.   How to write a formula on C5?  Thanks.    

[#2 · Accepted solution]

@rossshah

In C2:

=IF(AND(A2="",B2=""),"",IF(AND(A2="active",B2="active"),"ok","not ok"))

Fill down.

[#3]

Thanks . Worked Perfectly.

[#4]

@rossshah 

=CHOOSE(COUNTIFS(A2:B2,"active")+1,"","not ok","ok")

[#5]

Thank you. Worked perfectly. I did not know about choose.