|
SPECIALISTS IN PERSONAL & ORGANISATIONAL PRODUCTIVITY Phone: +61 421 551 254 Email: wakelinsolutionz@bigpond.com |
|
Avoid the #DIV/0! error occurring
The #DIV/0! error occurs when you try to divide an amount by 0. This error will flow through to any other calculations referring to that cell, causing errors throughout your worksheet.
To avoid the error, use an If and IsError function. E.g. you want do divide cell B3 by cell B2. The formula to type into cell B4 will be
=If(Iserror(B3/B2),0,B3/B2)
This formula will put a 0 in the cell where it would normally return #DIV/0!. If the division does not return an error, it will put the answer of B3/B2.
|
||
|