MrPink1986
Active Member
- Joined
- May 1, 2012
- Messages
- 252
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?
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?