Hello All:
I have this formula:
=IF(C8*C9*C9*C10*C11*C12*C13*C14*C15=0,"",SUM(C8:C 15))
How can I condense this group, C8*C9*C9*C10*C11*C12*C13*C14*C15, to the
same type of notation as the grouping of C8, C9, C10, …C15 =(C8:C15)? Is
there a way to specify, “if this cell or this cell or this cell etc.” a
shorter way, or do we just have to type out the whole shebang?
Thanks in advance for any help that can be offered.
Best regards to all,
Thomas
--
thomasstyron
------------------------------------------------------------------------
thomasstyron's Profile:
http://www.excelforum.com/member.php...o&userid=25568
View this thread:
http://www.excelforum.com/showthread...hreadid=393933