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

F

Fred Smith

Yes, your formula checked only AP2 for zero. But the error is dividing by
zero, so you need to check the divisor, AO2, for zero.

Regards,
Fred.
 
D

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?
 
D

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.
 
K

kevin

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

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
 
E

Elaine

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

=100%-I8

Thanks!
 
G

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
 
D

David Biddulph

If you're getting #Div/0! from =100%-I8, it's because I8 has the error
#Div/0!
You could test for the divisor in I8 being zero, and if so set your formula
result to zero.
 
Top