Thanks

SO what can I do in those cases where a9=0 I am calculating growth and if
a9=0 and c90 then I need to show growth (100%)rather than the error

"Luke M" wrote:

If A9 = 0, but C9<=0, then you are doing the math operation of C9/A9. (which
leads to division by zero).

Note also that the first part of your formula checks if C9=0 and A90, and
if true, to do C9/A9-1. This will always results in -1!

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Curtis" wrote:

Why am I getting an error #DIV/0!

Note
a9=0
c9=0

=IF(AND(A90,C9=0),C9/A9-1,IF(AND(A9=0,C90),"100%",C9/A9-1))

Thanks