If's formula help

Occasional Contributor

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)))))))))))

 

 

111222225_0-1650316809124.png

 

4 Replies
So if L7 = "Y", you want to run your formula. But if L7 does not equal Y, you want it to say "False"?

If so, just add one more If at the front =IF(L7="Y",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))))))))))),"False")

If not, please clarify. Thanks!
If L7 is "y" run formula:

IF(C7="Manager",IF($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)))))))))))

but if blank to run
=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)))))))))))
Okay, try the following:
=IF(L7="Y",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),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),"")))))))))

@111222225 

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")