Answer Posted / Shrishti
In Excel, division by zero returns an error. To avoid this, you can use IFERROR function to replace the division by zero with a value (e.g., zero). For example: =IFERROR(A1/B1, 0) will return A1/B1 if B1 is not zero, and it will return 0 if B1 is zero.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
