If, AND, OR in the same formula

[MrPink1986]

Hi there,

I am trying to create a formula that if the criteria in column D = Z and either the value (OR) in E2 or F2 is blank to return the value "Check"

=IF(AND(D2="Z",OR(ISBLANK(E2)="True",ISBLANK(F2)="True")),"Check","Fine")

My formula does not evaluate correctly above - any ideas?

 

[Special-K99]

IF(AND(D1="Z",OR(E2="",F2="")),"Check","something else")

 

[Fluff]

Remove the " from the word True

 

[MrPink1986]

Sweet - thanks you - not sure why I went with isblank when "" would have been perfect.

 

[MrPink1986]

Two in a row - excellent that also worked - thanks for that.

 

[Fluff]

Glad we could help & thanks for the feedback