Practical Microsoft Office, Excel and Outlook help for everyday work
Category archive

Excel formulas

Excel formula fix divide by zero errors: choose the right fix
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.