Category archive
Excel formulas
Excel formulas
Excel formula fix divide by zero errors: choose the right fix
Use IF(B2=0,"",A2/B2) for zero, IF(B2="","",A2/B2) for blanks, and IFERROR only when any error should be hidden.
Use IF(B2=0,"",A2/B2) for zero, IF(B2="","",A2/B2) for blanks, and IFERROR only when any error should be hidden.