MCQs > Finance & Management > Excel > I'm trying to work out percentage increases but when one of the cells has 0 in it its giving me DIV/0 error, How do i stop this?

Excel MCQs

I'm trying to work out percentage increases but when one of the cells has 0 in it its giving me DIV/0 error, How do i stop this?

Answer

Correct Answer: =IF(ISERROR(A1/B1),"",A1/B1)

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it