#DIV/0! error

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!!!!

Hi Jesse!

One way:

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Hi

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

--
Andy.


"Jesse" wrote in message
...
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!!!!

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

--
Regards
Frank Kabel
Frankfurt, Germany


Andy B wrote:
Hi

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


"Jesse" wrote in message
...
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!!!!

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!!!
-----Original Message-----
Hi Jesse!

One way:

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia



.

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.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

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