Hey there! I can definitely help you with that. The reason you're getting the #DIV/0! error is because you're trying to divide by zero, which is not possible. However, you can use an
IF statement to check for this error and display 0% instead. Here's how you can do it:
- Click on the cell where you have the formula that is giving you the #DIV/0! error.
- In the formula bar, replace your current formula with the following formula:
Formula:
=IF(E34=0,0%,(E34-D34)/E34)
- Press Enter to apply the formula.
What this formula does is it checks if E34 (the denominator) is equal to zero. If it is, it displays 0%. If it's not, it performs the calculation as before.