Dealing with zero values

Closed

sphillips - 15 Jun 2009 à 14:58
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 15 Jun 2009 à 20:39

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

Dealing with zero values
Based on the values in cells b77 - Excel Forum
Conditional formatting cells A and B based on value in C - Excel Forum
Code to move rows into another sheet based on certain values ✓ - Excel Forum
Mtu values - Guide
Conditional formatting between two values ✓ - Excel Forum

1 response

Réponse 1 / 1

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
15 Jun 2009 à 20:39

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

help me to add particular cells

Fill adjacent cell with number from text answer

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

Return Seq Values Until Blank value then return different set of seq values

Excel function question

Similar discussions

Subscribe To Our Newsletter!