Can't get formula to return blank if no input values?

[Deus_Ex_Machina]

Hi All,
So I'm trying to return a value of "Elite", "Athletic", "Average" or "Requires Conditioning" in the formula cell based on single leg jump height in cm (enetered into E69 and F69 compared to a percentage of leg length ($H$4 in the formula). The formula will take the lowest jump height of the left or right leg SMALL(E69:F69). Now this is all working except if the input cells are empty in which case I get a #NUM ! error. I have tried two AND functions to try get the last logic equation to say it fits "requires conditioning" but is also above "0" but I keep getting the error. Any ideas?

Thanks in advance


=IF(SMALL(E69:F69,1)>=$H$4*C69*2,"ELITE",IF(SMALL(E69:F69,1)>=$H$4*C69*1.5,"ATHLETIC",IF(SMALL(E69:F69,1)>=$H$4*C69,"AVERAGE",IF(AND(E69<$H$4*C69,E69>=0,"REQUIRESCONDITIONING",IF(AND(F69<$H$4*C69,F69>0,REQUIRESCONDITIONING,"")))))

=IF(SMALL(E69:F69,1)>=$H$4*C69*2,"ELITE",IF(SMALL(E69:F69,1)>=$H$4*C69*1.5,"ATHLETIC",IF(SMALL(E69:F69,1)>=$H$4*C69,"AVERAGE",IF(AND(SMALL(E69:F69,1)<$H$4*C69,(SMALL(E69:F69,1)>0)),"REQUIRESCONDITIONING",""))))

 

[Michael M]

Maybe this....

=IF(OR(E69="",F69=""),"",IF(SMALL(E69:F69,1)>=$H$4*C69*2,"ELITE",IF(SMALL(E69:F69,1)>=$H$4*C69*1.5,"ATHLETIC",IF(SMALL(E69:F69,1)>=$H$4*C69,"AVERAGE",IF(AND(E69<$H$4*C69,E69>=0),"REQUIRESCONDITIONING",IF(AND(F69<$H$4*C69,F69>0),"REQUIRES CONDITIONING"))))))

 

[Deus_Ex_Machina]

Thanks a tonne Michael, I actually merged the last two logic tests and brought into line with the rest as my >=0 wasn't doing anything for them. Your addition at the start was the missing piece to get it to show blank with no entries, thank you.

Finished prod:

=IF(OR(E69="",F69=""),"",IF(SMALL(E69:F69,1)>=$H$4*C69*2,"ELITE",IF(SMALL(E69:F69,1)>=$H$4*C69*1.5,"ATHLETIC",IF(SMALL(E69:F69,1)>=$H$4*C69,"AVERAGE",IF(SMALL(E69:F69,1)<$H$4*C69,"REQUIRES CONDITIONING")))))