If Function Function

A

aetejada

okay. So I am trying to workout a formula to compute a commision earning.
Basically, if X amount of new business is made, then X*Y (corresponding
Commision rate percentage), but if new business =<X, then X*Y (Commision rate
percentage that is true).

Problem is, it's super confusing...anyone have any suggestions?
 

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

IF previous cell value is < 0,(neg)then add it to this cell value 1
Find value within a range and extrapolating....(tiered commission) 1
HELP!! New to Excel. Need complex SUMIF. 0
Formula, Pivot Table, ??? Beats me 2
if statement confusion 10
Excel if Functions 1
Set non-continuous PrintArea via Function / Name 0
if statement issues. 2

Top