#DIV/0 Error

Brass Contributor

=(IF((AND(V5>8)),$T5/8,$T5/V5)

 

How do I get this formula to return 0 instead of a #DIV/0 error?

3 Replies
=IFERROR( IF(V5>8, $T5/8, $T5/V5), 0)

 

=IFERROR($T5/MIN(8, V5), 0)

= IFS(divisor>8, value/8, divisor>0, value/divisor, 1, 0)