Rept formula with Negative Values

I have set up a REPT function to show a stencil bar. However if value in Col A is negative, I comes up with #value!

I would like to show a downward facing bar in red for negative values

It would be appreciated if someone could advise me on how to overcome this