Combing two formulas

[leedalton]

I am trying to combine the following formulas in one cell but can't figure it out:
=IF(K3="","",IF(OR(F3<60,H3<60,J3<60),"FAIL",""))
=IF(K3="","",IF(AND(F3>59,H3>59,J3>59),"PASS",""))

 

[RSXchin]

alphafrog's is betterer than mine

 

[AlphaFrog]

Is this what you want...
=IF(K3="","",IF(AND(F3>59,H3>59,J3>59),"PASS","FAIL"))

Or are you trying to test if the three cells are decimal values between 59 and 60?

 

[leedalton]

No, if the value in any of the cells is less than 59 than it is a fail. If all of the values are 60 or higher than it is a pass. Tried your formula everything came back fail.

 

[AlphaFrog]

This tests if the three cells are between 59 and 60...
=IF(K3="","",IF(AND(MIN(F3,H3,J3)>59,MAX(F3,H3,J3)<60),"PASS","FAIL"))

 

[leedalton]

I need to know if they cells are 59 or less (fail) and 60 or greater (pass).

 

[AlphaFrog]

This tests if ALL three are greater than or equal to 60. If they are then it's a "Pass". If ALL three are not greater than or equal to 60, then at least one must be less than 60 so it's a "Fail".

=IF(K3="","",IF(AND(F3>=60,H3>=60,J3>=60),"PASS","FAIL"))

This ignores blank cells. Do you need to test if all three cells (F3,H3,J3) are filled in as well?

This is the same as above except it makes sure all 4 cells (F3,H3,J3,K3) all are filled in with something first
=IF(COUNTA(F3,H3,J3,K3)<4,"",IF(AND(F3>=60,H3>=60,J3>=60),"PASS","FAIL"))

 

[leedalton]

I think that worked.

 

[T. Valko]

No, if the value in any of the cells is less than 59 than it is a fail. If all of the values are 60 or higher than it is a pass. Tried your formula everything came back fail.

What about empty cells?

Will there always be 3 numbers?

If not, then what should happen?

 

[leedalton]

I have a second set of formulas I want to combine. This is more complicated.
First I put the gender, either M or F in a cell, I want the new formula to read the "Gender" cell then use the appropriate formula to run the lookup.
The lookup functions work and the tables are built.

=IF(OR(D2="",D2<17,E2=""),"",VLOOKUP(E2,'Male Tables'!A4:K77,IF(D2>61,11,ROUNDUP((D2-16)/5+1,0)),TRUE))
=IF(OR(D4="",D4<17,E4=""),"",VLOOKUP(E4,'Female Tables'!A4:N50,IF(D4>61,11,ROUNDUP((D4-16)/5+1,0)),TRUE))