Displaying zero values and percentages.

[podge2010]

Hi
I need help with an efficiency work sheet i am doing for work.I have 2 problems as follows:

1. if zero is entered as a value or there is no value ,i get #DIV/0 displayed in cells which are calculated from that entry.How can i have a zero displayed.

2.I have a row of percentages for staff efficiency for a week.What would be the equation for the total percentage for that week?

Thanks in advance.

[Richard Buttrey]

Hi,

1. Just wrap your formula in an =IFERROR() function. i.e.
=IFERROR(yourformula,0)

2. =SUM(the_total of the numerator values_used_by_your_%calculations/the_total of the denominator values_used_by_your_%calculations)

Regards

[podge2010]

Thanks for your help