At an academy I remember Andrew showing that you should be able to change what Error! comes up as on the statement, but I can't find that note.

I have a formula that is reading two cells which are both zero since nothing is posted to date in those accounts, instead of returning a zero percent it is returning Error!

Maybe I am doing something wrong, but the same formula is being used throughout the spreadsheet and it only appears in such situations where both cells are zero.

Can anyone help?

Where you have "A/B" change to "if (B=0,0,A/B)"

Thanks Michael, that worked.