# If's formula help

Occasional Contributor

# If's formula help

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

4 Replies

# Re: If's formula help

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!

# Re: If's formula help

If L7 is "y" run formula:

but if blank to run

# Re: If's formula help

Okay, try the following:

# Re: If's formula help

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