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

Try this

=IF(sum(C8:E8)=0,"",sum(C8:E8)/3)
--
HTH...

Jim Thomlinson


"MWH" wrote:

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

Thanks Jim...... Works!



"MWH" wrote in message
...
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

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