Hello All,
I am trying to build a spreadsheet to generate sales commission if their production is over a certain amount.
For instance, if they produce $1.25mil they get $1.25 per thousand dollars if it below $1.25mil it will be $1 per thousand. So if they do the $1.25mil their commission...