View Single Post
  #1   Report Post  
Paul
 
Posts: n/a
Default IF Statement with Average Function results in #Value!

I wrote an IF Statement that takes the Average of a group of cells based on a
certain condition.

Here is the Formula:

{=AVERAGE(IF(($A$30:$A$515=A1)*($H$30:$H$515=B1),$ Q$30:$Q$515))}

When a add a second part to the IF statement, I receive the error message
#Value! I am able to add a number, but not text. Example:

{=AVERAGE(IF(($A$30:$A$515=A1)*($H$30:$H$515=B1),$ Q$30:$Q$515),"FALSE")}

I want to add the "FALSE" LOGIC TO MY IF Statement.

Ideas?