mark, try this formula

=IF(SUM(C8:E8)/3=0, "", SUM(C8:E8)/3)


Here is a calculation if I want it to show no value (Blank) what do I need
to add?

=SUM(C9:E9)/3

I've tried this =IF(C8:E8/3=0,"",C8:E8/3=0) and I get a $VALUE! error

--
Mark W. Hanford