Biff,
I need to somehow make the cell =TEXT and not #DIV/0!. This cell is linked
to another workbook where I take the average of mutiple workbook cells. If
this cell = #div/0!, then the average cannot be taken.
For Example, Workbook1 A1 =5 and Workbook2 A1=5 and Workbook3 =#div/0! then
when I take the average of the three workbooks, I get #div/0!

"Biff" wrote:

Hi!

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

Well, for starters you have the "FALSE" as an argument in
the AVERAGE function. That's why you're getting #VALUE!.

What do you want the FALSE logic to mean?

If (A30:A515=A1 * H30:H515=B1) = 0, you'll get a #DIV/0!
error. Is that what you want the FALSE logic to mean?

If so, try this: (array)

=IF((A30:A515=A1)*(H30:H515=B1)=0,"FALSE",AVERAGE( IF
((A30:A515=A1)*(H30:H515=B1),Q30:Q515)))

Biff

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

.