I am trying to get this to work, I need help,
in my worksheet in column C I have the number of votes for one thing, in
column F the number of votes for another, these two total in column I, then I
want column D to give me the % that column C is of column I and column G to
also give me the percentage that column F is of column I, When I put the
formula in that seems rational for columns D and G I the cells read #DIV/)!,
which is telling me that it is trying to divide by 0, how can I get that to
not show up in the cell? Next I have column D and G totaling into column J.
The final part is that I am trying to get column K to read 1 if there is a
number in column I, but the IF formula (=IF(ISBLANK(I6),0,1) reads the 0 the
formula in column I and puts a 1 there,, HELP!