Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Hello all , is it possible to add a match x 2 to the beginning of this function .
I would like the 1st match too look at col BJ2 only and if it says Fast or Good and from col CK2 if it matches 1 or 13 , then for the rest of the function to kick in .
=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),)))
Thanks .
I would like the 1st match too look at col BJ2 only and if it says Fast or Good and from col CK2 if it matches 1 or 13 , then for the rest of the function to kick in .
=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),)))
Thanks .