Hi

First time poster!

This is probably a really basic one for most people but i'm having trouble with it. Trying to figure out a formula for the below:

IFERROR Question.jpg

As you can see I've currently got a very simple setup. In column D I've got the formula =C1/B1 and this works fine until i drag it down and get the divide by zero errors.

I'm trying to incorporate an IFERROR function so i don't have to manually change every cell that has this error, however, i want 2 different outcomes. I want to show 0% if B is zero and A is Zero and i want to show -100% if B is zero and A is more than zero.

(I know that technically there is no correct answer to dividing by zero and i don't want to get into that argument)

Can anybody help?