IF to return ""

[Avalanchez]

How do I add if this formula = 0 then the cell will be blank?

=IF(OR(D9>0),(SUM(((D8:D9)+(E8:E9))/2)),SUM((D8)+(E8)))

and same with this iferror return blank
=IF(OR(D9>0),(((AVERAGE(F8:F9))/SUM(((D8:D9)+(E8:E9))/2))),((F8))/((D8)+(E8)))

 

[Joe4]

Which version of Excel are you really using for this (for some reason, you seem to have them all listed in your profile, so we cannot tell which version you are currently using).
If Excel 365, I would make use of the new LET function, i.e.

=LET(x,IF(OR(D9>0),(SUM(((D8:D9)+(E8:E9))/2)),SUM((D8)+(E8))),IF(x=0,"",x))

Or if it just a visual thing, you could simply apply Custom formatting or Condiitonal Formatting to hide the zeroes, i.e. Display or hide zero values - Microsoft Support

 

[Avalanchez]

Which version of Excel are you really using for this (for some reason, you seem to have them all listed in your profile, so we cannot tell which version you are currently using).
If Excel 365, I would make use of the new LET function, i.e.

=LET(x,IF(OR(D9>0),(SUM(((D8:D9)+(E8:E9))/2)),SUM((D8)+(E8))),IF(x=0,"",x))

Or if it just a visual thing, you could simply apply Custom formatting or Condiitonal Formatting to hide the zeroes, i.e. Display or hide zero values - Microsoft Support

that works. Lets say i didnt have LET, how would I write that?

 

[Joe4]

You would have to double-up your equation, i.e. structure it like this:

=If(equation=0,"",equation)

By the way, I think the SUM in this part of your equation is redundant and unnecessary:

SUM((D8)+(E8)))

Either just use:

SUM(D8:E8)

or

D8+E8

No need for SUM and +, as they both do the same thing when only dealing with 2 cells!