Percentage #DIV/0!

[mantona]

Producing a report. How can I stop the percentage I'm calculating on all cells from displaying #DIV/0! when no data is supplied?

Thank you

 

[VoG]

Try like this

=IF(B1="","",A1/B1)

 

[mantona]

Thank you. I have modified slightly to read.

=IF(F2=0,"N/A",F3/F2)

Thanks so much for your help

 

[shristinlea]

A nice quik way (if you have the 2007 version) is:

=iferror(A1/B1," ")

If you have an earlier version its:

=if(iserror(A1/B1," ",A1/B1)