#DIV/0! error

[Jesse]

i created a formula in a cell b4 as follows: =(c4/c2)
there is nothing in c2 yet becasue it is for data for the
month of august, so in b4 I get the #### error, and all i
want it to say is 0% until new data is entered in c2
it looks sloppy this way, can anyone help?
can i change the formula to say it's okay to divide by
zero and get zero as the result?

thank you for any help!!!!

 

[Norman Harker]

Hi Jesse!

One way:

=IF(ISBLANK(C2),0,C4/C2)

 

[Andy B]

Hi

Try this:
=IF(C2=0,0,C4/C2)

 

[Frank Kabel]

Hi
try
=IF(N(C2),C4/C2,0)

 

[Guest]

hi Norman, thanks for your quick response!!

I just tried that and it didn't work??

i actually gave you the wrong letters but i don't suppose
it matters....

in L3 i have the formula: =(M3/M2)
there is no data in any of these 3 cells yet, so when
there is no data I want L3 to say 0% until I put data in
m3 and m2....

or even if the data in m3 and m2 is zero at the end of the
month i still want l3 to do the math and come up with 0%

so confused!!!

 

[Norman Harker]

Hi Jesse!

To cover the dual requirement of adjacent cells being empty you can
use:

=IF(COUNT(M2:M3)<>2,0,M3/M2)

COUNT counts cells with data (more correctly, numbers and also numbers
within the list of arguments in them). Thus if one or both cells is
empty, the count will not be = 2 and the formula will return 0.

 

[Jesse]

got it, thank you for all your help!!!