#div/0!

  • Thread starter Thread starter srctr
  • Start date Start date
S

srctr

I have a formula

=IF(H2=0, "0.00%", H2/F2)

This works great if H2 is zero. But if F2 is zero I get the #DIV/0! error.
I tried the following

=IF(ISERROR(H2/F2),"0.00%",H2/F2)

However it gives me 0.00% if F2 is zero but gives me 0 if H2 is zero.

I want the answer 0.00% if either H2 or F2 are zero.

I do I do that? Thanks
 
srctr said:
I have a formula
=IF(H2=0, "0.00%", H2/F2)
[....]
I want the answer 0.00% if either H2 or F2 are zero.
Click to expand...

And I suspect you want the __number__ 0.00% in both cases, and x.xx% in all
other cases.

To that end, try:

=if(F2=0, 0, H2/F2)

formatted as Percentage with 2 decimal places (click on Format > Cells >
Number).


----- original messages -----
 
Hi,

Try

=IF(F2=0,0,H2/F2)

and format the cell to percent 2 decimals. Or if F2 will be blank but no a
0, you could use

=IF(F2,H2/F2,0)


Note the problem with using "0.00%" is that the entry is text and this may
result in problems elsewhere.
 
Thanks everyone for your help. I liked the formulas that actual left it as a
number instead of text.
 
Back
Top