Jun 14 2022 12:35 PM
=(IF((AND(V5>8)),$T5/8,$T5/V5)
How do I get this formula to return 0 instead of a #DIV/0 error?
Jun 14 2022 01:12 PM
Jun 14 2022 01:45 PM - edited Jun 14 2022 01:46 PM
=IFERROR($T5/MIN(8, V5), 0)
Jun 14 2022 02:08 PM