View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default how to compute a range of cells based on another range of cells?

Nothing wrong with the first part

=AVERAGE(E8:AH8)*.33

What in the world are you trying to do with the second part?

IF (E3:AH3, "HW")

Are you trying to append that to the first part? (If so, you cannot do it
the way you are trying to) Do you want an "HW" to appear at the end of the
result, but only under certain circumsatnce?

A little color will help us help you

"HAROLD" wrote:

What is wrong with this formula? =AVERAGE(E8:AH8)*.33 IF (E3:AH3, "HW")