Forum Discussion

mrkitt's avatar
mrkitt
Copper Contributor
Apr 27, 2021

Advanced If Formula Help

Hi how can I make this  formula work ? Currently itshowing error   =(IF(E12="Handbags"),(E13>4994),(E13*0.2),IF((E13>995),(E13*0.3),IF((E13>145),(E13*0.5),IF((E13<146),(E13*0.6)))), (IF(E12="ACCESS...
excel
SergeiBaklan's avatar
SergeiBaklan
MVP
Apr 27, 2021

mrkitt 

I guess that is something like

=IF(E12="Handbags",    LOOKUP(E13, {0,145,995,4995},{0.6,0.5,0.3,0.2}),
 IF(E12="ACCESSORIES", LOOKUP(E13, {0,145},{0.6,0.5,}),
 IF(E12="HOME ITEMS",  LOOKUP(E13, {0,145,995},{0.6,0.5,0.3}),
 IF(E12="WATCHES",     LOOKUP(E13, {0,145,995,2495},{0.6,0.5,0.3,0.2}),
 IF(E12="JEWELRY",     LOOKUP(E13, {0,145,995},{0.6,0.5,0.3}),
    "no match")))))

Resources