Showing posts with label Formula. Show all posts
Showing posts with label Formula. Show all posts

Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!!

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

Hot Game !!!