If Match x 3 Roundup .

[Sunline]

Hello all , im wanting to know if its possible to add another 2 x Match only to the begining of this function .
=IF(ISNUMBER(MATCH(BM2,$FF$41:$FF$44,0)),IF(AND(EG2>=0.1,EG2<=4.6),21-ROUNDUP(EG2/0.5,0),0),IF(ISNUMBER(MATCH(BN2,$FF$41:$FF$44,0)),IF(AND(EH2>=0.1,EH2<=4.6),21-ROUNDUP(EH2/0.5,0),0),IF(ISNUMBER(MATCH(BO2,$FF$41:$FF$44,0)),IF(AND(EI2>=0.1,EI2<=4.6),21-ROUNDUP(EI2/0.5,0),0),)))

So right at the beginning i would like to 1st match from col BJ2 only if it says Fast or Good and from col CK2 1 or 13 , then for the rest of the function to kick in . Thanks .

 

[DonkeyOte]

In general terms regards your additional tests:

=IF(OR(AND(BJ2<>{"Fast","Good"}),AND(CK2<>{1,13})),"",...)

If you split out the calculation such that you return 1 to 3 based on match of BN2:BO2 you could condense given repetition.

 

[Sunline]

Thanks for that .
Im not sure how to attach this to my existing one . Thanks .