if and conditional formulas

N

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate results of scores and return sum of percentages 4
Payment calculation 1
accurately payservices both scheduled and actual cases. 0
Joining IF Statements 3
Word macro that can call cells out of Excel for a find and replace 0
Calculate total metric based on sum of metric over specific time f 1
Excel formula 9
If And/Or statement for comm calc criteria 4

Top