ExcelBanter - Formula question?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula question? (https://www.excelbanter.com/excel-programming/338855-formula-question.html)

MWH

Formula question?

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

Jim Thomlinson[_4_]

Formula question?

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

MWH

Formula question? Thanks!

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

Steve[_63_]

Formula question?

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

All times are GMT +1. The time now is 09:51 AM.