Wildcard in formula producing ‘False’

Hi, I am trying to use a wildcard in a formula but it is producing a result of ‘false’ instead of the answer. If i remove the wildcard the formula works fine. From what I have read it looks like the wildcard doesnt work with = in the formula but I dont know how to rewrite the formula not to include the equals sign, Can anyone help?

 

=IF(G5<=TODAY()-10,IF(J5=”Sent*”,”Overdue”),””)

 

Thanks in advance, Stuart

By: Stuart Dudley

Leave a Reply

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