if and conditional formulas

[Newsgal]

I need a conditional formula for a commission worksheet that drives one
commission payout based on the first argument, another payout based on the
2nd argument and $0 otherwise. Is there a way to get more than just one value
if True, just one value if False limitation?

=IF(AND(M11<100%,M11>=98%),D16,IF(M11>=100%,D17),if(M11<98%,0)))

 

[Teethless mama]

=LOOKUP(M11,{0,0.98,1},{0,"A","B"})

 

[Newsgal]

That worked! Thank you!!!
--
News Gal

=LOOKUP(M11,{0,0.98,1},{0,"A","B"})