Multiple IF Statement with text & wildcard

Hi, I need help in creating a multiple if statement with text & a wildcard. I have an existing formula that works, here, 

 

=IFERROR(IFS(G34<=TODAY()-10,IFS(J34=”Sent”,”Overdue”, J34=”Sent to Bean”,”Overdue”)),””)

 

what I need to do is only have this run if the prefix of the reference on column A starts with OLP (the cell contains a reference number i.e. OLP1234

 

I thought I could just add another if statement with a wildcard “OLP*” at teh beginning but it just wont work, can you help?

By: Stuart

Leave a Reply

Your email address will not be published. Required fields are marked *