I need a clarification....

Are you saying that:
Col_A will still contain the hyperlink destination text
and
Col_E will contain a numeric value
AND
you want to only create hyperlinks in Col_A where the
corresponding Col_E value is greater than zero?