Thread: Using functions to calculate multiple scores according to their level of difficulty
View Single Post
  #2   Report Post  
GaryDK
 
Posts: n/a
Default
Hi,

If you enter this as an array formula (see help if you don't know about
array formulas), it general syntax should do what you need -

=SUM(IF(A2:C2="e",A1:C1,A1:C1*10))

Gary

Reply With QuoteReply With Quote