Problem with Excel.

princejim · 30 Nov 2009 at 10:51

Problem with Excel.

I am working out the percentage for two cells however, if the cells have 0’s in them I get #DIV/0 in the answer cell, formula = (KS215/KS214*100 ) question how do I make the answer cell = 0 if this happens, these cells are dynamitic and can change with time? Thanks.

princejim · 30 Nov 2009 at 12:36

That works for 0 but if there are values in the cells in gives a blank answer cell? Thanks anyway.

princejim · 30 Nov 2009 at 13:12

I clay shoot, and this is to work out my hits average.
Chosen 2 more cells, so cell NI97=NI99/NI98*100 gives me %

NI99 total clays for gate =56
NI98 Total Hits for gate =37

But on the weeks I have yet to shoot the cells will contain 0

This is for 1 day, then I duplicate the table for each day we shoot in the month.
I have now done as you suggested and changed the answer cell to percentage.
If I put your equation in I get 0 even though the 2 cells have numbers in them?

Thanks for your help.

princejim · 30 Nov 2009 at 15:55

div0, thanks mate that works a treat. Thanks for all your help if you ever want to try Clay Shooting get in touch. Thanks again.

You do live upto your name.

Jim.