If multiple cells are blank or a one specific cell has data
I am trying to achieve this - If the action required by and the data processed is blank or the action required by = "DAT", then "DAT" is the correct response.
This what I have come up with =IF(OR(AND(ISBLANK([Action Required by]1), ISBLANK([Data Processed]1)), ([Action Required by]1=DAT)), "DAT")
Am not sure how to fix
Help Article Resources
Check out the Formula Handbook template!