Any ideas on how I can overcome getting an answer #DIV/0! I am using the following formula but the problem is that some of the data is zeros and I get the answer #DIV/0! when it it (0/0)*100.

=('Full Fields'!BZ7/'Full Fields'!BY7)*100

Is there an alternative formula that I could use to overcome this?

Thanks
Twodogs