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