how to remove #DIV/0 error

[penfold1992]

I have a simple formula that calculates the percentage from two numbers.
the numbers are inputted weekly so i have week numbers from 1-52 already set out.

We are currently on week 42 so up until week 42 works correctly however all the fields after that give back the result
#DIV/0!
I know why this is, because there is nothing in the columns (yet) but i still want the formula to be in the box for the future.
(also because i create a graph from the data the error values cause issues)

is there a way I can remove these errors just so that you cant see them but if the cells it refers to DO get filled in, it updates correctly with a percentage.

[Marcol]

Wrap your formula in IFERROR()

=IFERROR("your formula","")

Or for 2003
=IF(ISERROR("your formula"),"","your formula")