See how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month. See an amazing formula from Dave Patton at the Mr Excel Message Board. Download file: flightline.highline.edu
http://www.youtube.com/watch?v=bfUIwZ7apkk&hl=en
Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!!
Labels:
Amazing,
Commission,
Formula,
Lookup,
Solution,
SUMPRODUCT,
Varying
Subscribe to:
Post Comments (Atom)
Deixe o seu comentario
Post a Comment