Your formula will check if AD4 is either "A", "SU" or "GF" AND AF4 is not blank

That can be simplified to

=IF(AND(OR($AD4={"A","SU","GF"}),$AF4<""),"Update d Allowance is not
Applicable","")


Regards,

Peo Sjoblom



"DebbieK" wrote:

Here is my example - can I do this? What have I done wrong I can't get it to
work.

IF(AND(OR($AD4=€�A€�,$AD4=€�SU€�,$AD4=€�GF€� ),$AF4<€�€�),€�Updated Allowance is Not
Applicable€�,"")