I have a cell with a formula that do some calculations based on other cells values.
The problem is that I want to copy the formula to remaining cells that are not yet populated, and I’m getting this error on cells that contain the formula:
#DIV/0!
This error is normal because until I add new values, it will trigger a division by 0.
How can I hide this error or add a maybe add an if statement that checks “if cell is empty then don’t apply the calculation”?
Here is the formula:
=ROUND(B14*1/(G14*C14/100),6)
Where B14, G14 and C14 are empty by default but will receive values in the future.
Thank you.