Greater than and less than

[111222225]

HI 

I need some help.  If my labor difference is greater then 0%, make F7 say 'false', but if  = or less then to follow this 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)))))))))) 

[#2 · Accepted solution]

@111222225 

=IF(F4<0,FALSE,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)))))))))))

[#3]

Thank you!