I wish to search text in A1 for the word "div". If it is present I want
cell A6 to equal A4. If absent, I want cell A6 to be blank.

When '=IF(FIND("div",A1),A4,"")' is placed in cell A6 it gives '#Value'
instead of blank if A1 does not contain"div".

This seems trivial, but how do I remedy the situation?

Thanks