[volunteer]

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!

[Bob Phillips]

D6: =IF($I6=0,0,C6/$I6)
F6: =IF($I6=0,0,E6/$I6)

K6: =--($I60)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"volunteer" wrote in message
...
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!