Previous Topic Next Topic

Dealing with zero values

Closed
sphillips - Jun 15, 2009 at 02:58 PM
venkat1926 Posts 1863 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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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.

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
Name Values
brendanconlin -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses