The following is my code which is was working fine until i added the F19 formula bit,
=IF(F20="","",IF(AND((F15)>=$D$15,(F16)>=$D$16,(F17)>=$D$17,(F18)>$D$18),(F19)>$D$19),RANK(F20,$E$20:$AE$20),"FAIL"))
I initially thought it may have something to do with parentheses and added the extra brackets and then that arose with an error stating that there was something wrong with the Formula.
Any Ideas
=IF(F20="","",IF(AND((F15)>=$D$15,(F16)>=$D$16,(F17)>=$D$17,(F18)>$D$18),(F19)>$D$19),RANK(F20,$E$20:$AE$20),"FAIL"))
I initially thought it may have something to do with parentheses and added the extra brackets and then that arose with an error stating that there was something wrong with the Formula.
Any Ideas