i am trying to combine 4 different Array formula's. have tried some suggestions from this site but didn't work
ARRAYFORMULA(IF(AND(K6>0,K6<=15),VLOOKUP(D5,Data!$F$2:$L$7,2,FALSE),0))
ARRAYFORMULA(IF(AND(K6>=16,K6<=99),VLOOKUP(D5,Data!$F$2:$L$7,3,FALSE)))*K6
ARRAYFORMULA(IF(AND(K6>=100,K6<=249),VLOOKUP(D5,Data!$F$2:$L$7,4,FALSE)))*K6
ARRAYFORMULA(IF(AND(K6>=250,K6<=499),VLOOKUP(D5,Data!$F$2:$L$7,5,FALSE)))*K6
Hope someone can help to make this one formula
Aucun commentaire:
Enregistrer un commentaire