
Algebra PreAlgebra and Basic Algebra Math Forum 
 LinkBack  Thread Tools  Display Modes 
September 8th, 2017, 01:08 PM  #1 
Newbie Joined: Sep 2017 From: California Posts: 1 Thanks: 0  Excel Formula Help
I am trying to create a formula in excel for the bonus structure below. I would like to get all set up so all I have to do is just track my sales and it will calculate it for me. 1.) Receive 3.5% of sales over $53,000. 2.) Receive $1 per order over 485 3.) Receive bonus for Average order: $1  $30.99 receives $100 bonus $40  $49.99 receives $200 bonus $50  $59.99 receives $300 bonus $60  $69.99 receives $400 bonus $70  $79.99 receives $500 bonus $80  $89.99 receives $600 bonus $90  $99.99 receives $700 bonus $100 and up receives $800 bonus. 4.) $200 bonus if you go over $100,000 in sales 5.) $200 Bonus If you get an average of 2 or more items per order Again, I am trying to set this up in excel. So, if you could use excel formulas that would be great. Last edited by rfhitter; September 8th, 2017 at 01:48 PM. 
September 8th, 2017, 03:02 PM  #2  
Senior Member Joined: Sep 2015 From: USA Posts: 2,202 Thanks: 1157  Quote:
 
September 8th, 2017, 03:05 PM  #3 
Senior Member Joined: Sep 2015 From: USA Posts: 2,202 Thanks: 1157 
will you have a list of all orders? I'm curious how we are supposed to compute the average sale if not. 
September 8th, 2017, 04:22 PM  #4 
Math Team Joined: Oct 2011 From: Ottawa Ontario, Canada Posts: 13,624 Thanks: 954  

Tags 
excel, formula 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Excel formula help  CherryTash  Algebra  6  February 4th, 2016 06:23 PM 
Reverse compound interest excel formula?  Apple30  Elementary Math  3  February 6th, 2015 01:48 AM 
Excel Formula for Breakeven Interest Rate  RickOShay  Math Software  5  August 31st, 2013 11:01 AM 
Excel Exponential or Logarithmic Formula Help  Joey5105  Algebra  15  December 2nd, 2008 06:15 PM 
Excel Formula for Breakeven Interest Rate  RickOShay  Algebra  0  December 31st, 1969 04:00 PM 