Need help...getting #DIV/0!

[Peter McCaul]

My formula is

=if(sum(p6/o6)*100<=0,"",sum(p6/o6)*100)

The formula works fine if there are numbers in p6 and o6 cells. If I leave
it blank I get #VALUE! and if i put a zero I get #DIV/0!. Is there a
solution? Thanks for any help in advance.

 

[Roger Govier]

Hi Peter

Try
=if(o6="","",if(sum(p6/o6)*100<=0,"",sum(p6/o6)*100))


Regards

Roger Govier

 

[Gord Dibben]

Peter

You only have to check the "divide by" cell value.

=IF(O6="","",IF((P6/O6)*100<=0,"",(P6/O6)*100))

Note: you also don't need the SUM Function.


Gord Dibben Excel MVP

 

[Harlan Grove]

My formula is

=if(sum(p6/o6)*100<=0,"",sum(p6/o6)*100)

The formula works fine if there are numbers in p6 and o6 cells. If I leave
it blank I get #VALUE! and if i put a zero I get #DIV/0!. Is there a
solution? Thanks for any help in advance.

....

Sign is all that matters - you seem to want only positive results. P6/O6 > 0
necessarily implies O6*P6 > 0 unless O6 = 0, but you want to exclude that
case too. Try

=IF(O6*P6>0,P6/O6*100,"")