Avoiding formula error's in your excel spreadsheets

Avoiding formula error's in your excel spreadsheets

 

 

Example #DIV/0!

 

 

 

A1 = 10

 

 

 

B1 = 0

 

 

C1 = A1/B1

 

 

 

Output #DIV/0!

 

 

The above division would generate divide by zero exception. This can be removed by using:

 

 

=IFERROR (A1/B1,"")

 

 

Replacing the cell value as empty.

 

 

 

Or

 

 

 

=IFERROR (A1/B1,"Please check the values")

 

 

 

Displaying the comments