Dealing with zero values

Closed
sphillips - Jun 15, 2009 at 02:58 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jun 15, 2009 at 08:39 PM
Hello,
I am trying to calculate percentages using several different worksheets. I have 6 sheets total with 4 being daily and the last to mtd. I am trying to put in formulas for the month to date sheets but I keep getting #DIV/0! and VALUE# errors. Can you please give me a formula where it will not count or recognize any zero values?

thanks in advance!

S Phillips

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Jun 15, 2009 at 08:39 PM
suppose A1 is blank and B1 is having some number and C1 has the formula
=B1/A1 will give that error
insstead in C1 type ths formula

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

after the first comma it is two double quotes.
0