How do I make div 0 disappear in excel?
- 1 Answers
- 745 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How do you combine formulas?
How do I make an editable excel document online?
How do I get rid of bold lines in excel?
Can you sort in excel by bold?
How do I make a cell on excel?
How do you reverse a table in excel?
What is wrap text in excel?
How do I convert a number to text in excel?
Is excel a software?
How Can You Increase The Number Of Rows And Columns In A Worksheet?
What is a delimiter in excel?
How do you consolidate rows in excel?
MS Excel Microsoft 
