How to keep cell blank if formula = 0?

[doitright]

Hi all,

In document -> "dashboard" sheet -> cell B8
Currently cell B8 has the correct formula which calculates cells B6 / B5. It is also set to format custom 0% "WIN RATE"

But if the values of both B5 and B6 are 0, how would I make cell B8 appear blank? Currently when the values are 0 it shows as "#DIV/0!"
I would like it to only show the formula result if there is a 1 in both B5 and B6.

Thanks in advance all

[Gregb11]

Maybe wrap it in an IFERROR formula? Like this?
=IFERROR(SUMPRODUCT(COUNTIFS(Trades!N:N,"NO",Trades!C:C,{"LONG","SHORT"}))/SUMPRODUCT(COUNTIF(Trades!C:C,{"LONG","SHORT"})),"")

[doitright]

Hi Greg,

That works perfectly. Thank you so much!

[FDibbins]

HEres another option...
=IF(SUM(B5:B6)=0,"",SUMPRODUCT(COUNTIFS(Trades!N:N,"NO",Trades!C:C,{"LONG","SHORT"}))/SUMPRODUCT(COUNTIF(Trades!C:C,{"LONG","SHORT"})))

Note that using full column references with SUMPRODUCT could slow your file down - try to use only the range you need (if the range will grow, try 3-3 time what you need.)