IFERROR help

Question

What I am trying to do is use an IFERROR function to replace the #DIV/0! with a 0 value. Example 1 shows that if the event never happened. Example 2 shows the results if the event happened once. Example 3 shows the formulas used. Were I am confused is where the parenthesis go and the commas go in the IFERROR function to return the zero.

I've tried =IFERROR(B$5,($B$2-B2*-10),/$B$5,"0") and just about all combinations of commas but keep getting "not trying to type a formula" or "you have entered to few arguments for this formula". I did stab my brain with a q-tip this morning so it still hurts, so any advice I can get would help

Thanks

Example 1

Example 2

Example 3

Answer 1

a) You have to surround your whole calculation with IFERROR

b) Do not return "0" which is a text, return 0 which is a number

C2: =IFERROR(($B$2-B2)*-10/$B$5,0)

Andreas.

Answer 2

Thanks much, works perfect