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?
|