Change Links to avoid 0 Values showing

Hi, I have a ton of links to other worksheets that since no information is in the orginal cell the results come up as a zero value on the new sheet.

I really cant hide all the zeros in the options as some zero values I need to show but they are a much smaller number so it would be easier just to change all the current links.

What kind of script could I use to edit the current link to include the current link and add a if then statement to the formula.
Here is an example:
From:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

Thank You, Mike

Here what I came up with should anyone need it.

Please Login or Register  to view this content.

And this one below with hide div/0 errors

Please Login or Register  to view this content.

...

I'd prefer

Please Login or Register  to view this content.

I have to agree with you on that... Nice Work...

.