Does:

=IF(OR(LEFT(G21,4)="Bank",AND(G21="Bank Details"),(OR(J21="*** Deleted
***",J21="*** Created ***"))),TRUE,FALSE)

do what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


wrote in message
ps.com...
Hi,

Think I'm nearly there with my requirement but can't seem to get it
correct and into one formula!!

Basically need to look for where "*** Created ***" or "*** Deleted
***" appears within column J and Column G contains "Bank Details".
I've worked this formula out as per below:
=IF(AND(G21="Bank Details"),(OR(J21="*** Deleted ***",J21="*** Created
***")),)

However, I also need to have another IF statement in this formula for
if the above isn't appearing but the first four letters of column J
contains "Bank" then again show True. On it's own this formula would
do this:
=IF(FIND("Bank",J22)=1,TRUE,FALSE)

How do I basically combine this into one formula? This would be for
each row so obviously my example is just using the row underneath. In
summary:
- If entry in column J = *** Created *** OR = *** Deleted *** AND
entry in column G = "Bank Details" then put true.
- If first 4 characters within column J's entry = "Bank" then put
true

ELSE:
FALSE

Appreciate any help.

Thanks, Al.