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