Apr 18 2022 02:29 PM
Hi
I need some help, how do I added to this formula so that if cell L7 has 'Y' in it it will override 'false' and do the formula.
The example is that if the labor budget is greater then 0 the SALES BONUS PAYMENT will shows as false, but I want to be able to over
=IF(AND(C7="Manager",$F$4>0),FALSE,IF(AND(C7="Manager",$J$4>0%),IF($J$4<5%,(E7*0),IF($J$4<10%,(E7*1.5),IF($J$4<15%,(E7*2),IF($J$4<20%,(E7*2.5),IF($J$4<100%,(E7*3)))))),IF(C7="Assistant Manager",IF($J$4>0%,IF($J$4<5%,(E7*0),IF($J$4<10%,(E7*1),IF($J$4<15%,(E7*1.5),IF($J$4<20%,(E7*2),IF($J$4<100%,(E7*2.5))))))),IF(OR(C7="Sales Advisor",C7="Lead Advisor"),IF($J$4>0%,IF($J$4<5%,(E7*0),IF($J$4<10%,(E7*0.5),IF($J$4<15%,(E7*1),IF($J$4<20%,(E7*1.5),IF($J$4<100%,(E7*2)))))))))))
Apr 18 2022 03:03 PM
Apr 18 2022 03:09 PM
Apr 19 2022 06:22 AM
Apr 19 2022 09:42 AM
As variant
=IF($L$7 = "Y",
IF(
AND(C7="Manager",$F$4>0),
FALSE,
IF(AND(C7="Manager", $J$4>0%),
E7*LOOKUP($J$4, {-1, 0.05, 0.1, 0.15, 0.20}, {0, 1.5, 2, 2.5, 3}),
IF(C7="Assistant Manager",
E7*LOOKUP($J$4, {-1, 0.05, 0.1, 0.15, 0.20}, {0, 1, 1.5, 2, 2.5}),
IF(OR(C7="Sales Advisor",C7="Lead Advisor"),
E7*LOOKUP($J$4, {-1, 0.05, 0.1, 0.15, 0.20}, {0, 0.5, 1, 1.5, 2})
)))),
"not Y")