I am trying to build a waterfall calculation for commissions. I can't get the partial commissions in months when he is at two rates. Can anyone help? See attached. I am looking for a formula to copy down and use for multiple sales people based on the same criteria.
Greatly Appreciated.
Bookmarks