If multiple cells are blank or a one specific cell has data

Sally Osborne

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

Thanks

Shaine Greenwood

Hello Sally,

Looks like you're missing the quotes around one of your DAT values.

Try this formula:

=IF(OR(AND(ISBLANK([Action Required by]1), ISBLANK([Data Processed]1)), ([Action Required by]1="DAT")), "DAT")

Quotes always go around text strings, whether your formula is looking for a string, or returning a string.

Let me know if that doesn't work.