Thread: Change value based on another cell's value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Change value based on another cell's value
=IF(R1C3=0,0,SUM(R1C3:R20C3))

Also note that the use of sum for the product is redundant. A simple:

=r1c1*r1c2

would suffice.

HTH
Kostis Vezerides

Reply With QuoteReply With Quote