Getting #DIV/0!, how to get 0%?

[dnmusic]

ok, i have a formula that works but i want to have the cell blank when
nothing is in the other cells... =IF(ISERROR(F4/E4,0,F4/E4) which gives me
0.00 in cell G4. question is, what do i need to add to the formula to have
G4 blank until valves are added to cells F4 and E4... i.e. ,"", but i can't
get it right... any help?

 

[T. Valko]

Maybe this:

=IF(COUNT(E4:F4)=2,F4/E4,"")

 

[Dave Peterson]

Maybe you can check for numbers:
=if(count(e4:f4)<2,"",if(e4=0,0,f4/e4))

And I only checked for a non-zero denominator.

 

[kevin]

Check e34 prior to dividing.

if(e34 = 0, 0,(E34-D34)/E34)

 

[kevin]

I am still getting a Value after changing formula to instead of #DIV/0!
=IF(c13=0,0,(c12:c16)/c13

 

[Peo Sjoblom]

You are using a range divided by a number and you should change that to a
single cell

=IF(C13=0,0,C12/C13)


or something


and the only way you can get a value error is if C13 itself has a DIV error
in it.


Maybe you should explain what you are trying to do instead?

--


Regards,


Peo Sjoblom

 

[Elaine]

I am getting #Div/0! with the following formula.. I want it to display 0% in
the cell.

=100%-I8

Thanks!

 

[Gord Dibben]

You won't get #DIV/0! with that formula unless I8 is #DIV/0! to start with.

Correct the error in I8 would be my first step.

Or use this formula =IF(ISERROR(100%-I8),"",100%-I8)


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Correction......you wanted 0%

=IF(ISERROR(100%-I8),0,100%-I8)


Gord