About Us

MWH

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_]

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

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_]

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Question	carl	Excel Worksheet Functions	5	January 15th 10 11:20 PM
Newbie Formula Question - how to get formula to repeat in each subsequent row?	[email protected]	New Users to Excel	2	January 10th 10 05:02 PM
Formula Question	John	Excel Discussion (Misc queries)	6	May 13th 09 10:20 PM
what IF - formula question	Rasoul Khoshravan	Excel Worksheet Functions	4	October 13th 06 07:02 PM
Newbie Question - Subtraction Formula Question	[email protected]	Excel Discussion (Misc queries)	3	May 5th 06 05:50 PM

Menu

About Us