Remove #N/A from formula

[jpruffle]

Hi,

I have two formula which work fine, except if the value doesn't exist then it returns a #N/A result. Can you please advise on the two formula to stop the #N/A?

Formula One:

Please Login or Register  to view this content.

Formula Two:

Please Login or Register  to view this content.

Thanks in advance.

[jpruffle]

I have resolved it, just wrote the formula wrong.