if not available

  1. H

    Understanding IF NOT AVAILABLE STATEMENT

    Hi Guys, I'm very confused and not sure why my "IF NOT AVAILABLE" statement isn't working under certain scenarios. For example when I use the FIND function in the working code with the "IF NOT AVAILABLE" statement, the "UNAVAILABLE COLOUR" message is displayed as I expect. I can then amend the...
Top