What I am getting is a #N/A. If fugured because I am asking it to do something if the referenced cell equals or is greater than another number, but the referenced cell does not have any number in it.

Here is a much more detailed description of what I am looking at. I wrote this today to post on another board when Mr. Excel was down.

I am working on a fitness spreadsheet for my fire department. The hole is getting deeper and deeper. Before you start laughing if I am way off, I am a firefighter...

The following formula almost works for what I need it to do. There are a total of 12 conditions, however, the last four are part of an OR statement. Each of the four conditions in the OR statement need to have an AND as a condition that some number/value is actually in the referenced cells. Else, it would yield #N/A before ever yielding the desired "IRONMAN". The fact is that only one of the four referenced cells (M22, M23, M24, M25) is likely to have a number in it. The others are most likely going to be blank.

I have tried to bold the OR conditions to which I am referring.

So, how can I add some type of ISTEXT in an AND to the OR? Or, what else can I do to this formula yield "IRONMAN" if all initial conditions are met, and if at least one of the OR conditions has a value which meets it's condition?

=IFERROR(IF(AND(INDIRECT("'"&ROWS(A$1:A6)&"'!$B$3")="Male",INDIRECT("'"&ROWS(A$1:A6)&"'!$m$8")>=35,INDIRECT("'"&ROWS(A$1:A6)&"'!$m$8")<40,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$21")>='Current Average Comparisons'!$F$58,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$30")>='Current Average Comparisons'!$F$66,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$31")>='Current Average Comparisons'!$F$67,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$32")>='Current Average Comparisons'!$F$68,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$33")>='Current Average Comparisons'!$F$69, OR(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$22")>='Current Average Comparisons'!$F$59,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$23")>='Current Average Comparisons'!$F$60,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$24")>='Current Average Comparisons'!$F$61,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$25")>='Current Average Comparisons'!$F$62)),"IRONMAN",""),"")

Being over my head, here is somewhat of what I am thinking:

OR(AND(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$22")>='Current Average Comparisons'!$F$59),(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$22")=ISTEXT)),(AND(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$23")>='Current Average Comparisons'!$F$60),(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$23")=ISTEXT)),(AND(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$24")>='Current Average Comparisons'!$F$61),(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$24")=ISTEXT)),(AND(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$25")>='Current Average Comparisons'!$F$62),(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$25")=ISTEXT)))),"IRONMAN",""),"")

I tried this recommendation that someone gave, but it does not yield "IRONMAN" even for those who meet all the conditions. If I remove the IFERROR, it just yields #N/A unless I go add numbers to the empty (M-column) cells or to those (M-column) cells that have #N/A also.

=IFERROR(IF(AND(INDIRECT("'"&ROWS(A$1:A6)&"'!$B$3")="Male",INDIRECT("'"&ROWS(A$1:A6)&"'!$m$8")>=35,INDIRECT("'"&ROWS(A$1:A6)&"'!$m$8")<40,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$21")>='Current Average Comparisons'!$F$58,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$30")>='Current Average Comparisons'!$F$66,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$31")>='Current Average Comparisons'!$F$67,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$32")>='Current Average Comparisons'!$F$68,INDIRECT("'"&ROWS(A$1:A6)&"'!$M$33")>='Current Average Comparisons'!$F$69, OR(AND(ISNUMBER(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$22")),INDIRECT("'"&ROWS(A$1:A6)&"'!$M$22")>='Current Average Comparisons'!$F$59),AND(ISNUMBER(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$23")),INDIRECT("'"&ROWS(A$1:A6)&"'!$M$23")>='Current Average Comparisons'!$F$60),AND(ISNUMBER(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$24")),INDIRECT("'"&ROWS(A$1:A6)&"'!$M$24")>='Current Average Comparisons'!$F$61),AND(ISNUMBER(INDIRECT("'"&ROWS(A$1:A6)&"'!$M$25")),INDIRECT("'"&ROWS(A$1:A6)&"'!$M$25")>='Current Average Comparisons'!$F$62))),"IRONMAN",""),"")