Thread: How do I say…
View Single Post
  #1   Report Post  
thomasstyron
 
Posts: n/a
Default How do I say…


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