I have written this formula, but it doesn't work! I am trying to add 1 to the result of the first formula (in brackets), if there is a '&' symbol in AZ10. I think what is confusing it is that I mean for it to look for a & within text, for example, 'Mr & Mrs Smith'. For this reason, I included a ~.

The value returned for this formula is the correct result for the formula in brackets, but it does not add 1 where there is a '&' symbol on AZ10.

=((AZ22/$X$3*100)/100)+SUM(IF(AZ10="*~&*",1,0))

If anyone would be able to help fix this formula, I would be most appreciative.

Many thanks,

Holly