Dealing with zero values

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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.