My Math Forum Excel Formula Help

 Algebra Pre-Algebra and Basic Algebra Math Forum

 September 8th, 2017, 12: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 12:48 PM.
September 8th, 2017, 02:02 PM   #2
Senior Member

Joined: Sep 2015
From: USA

Posts: 2,430
Thanks: 1315

Quote:
 Originally Posted by rfhitter 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.
reposted to clean it up by escaping dollar signs

 September 8th, 2017, 02:05 PM #3 Senior Member     Joined: Sep 2015 From: USA Posts: 2,430 Thanks: 1315 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, 03:22 PM   #4
Math Team

Joined: Oct 2011

Posts: 14,418
Thanks: 1025

Quote:
 Originally Posted by rfhitter 1.) Receive 3.5% of sales over 53,000 dollars.
Unclear: receive nothing if =< 53,000 ?

Most other items also unclear...
Can you show an example of an actual case
covering all "bonuses"?

 Tags excel, formula

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post CherryTash Algebra 6 February 4th, 2016 05:23 PM Apple30 Elementary Math 3 February 6th, 2015 12:48 AM RickOShay Math Software 5 August 31st, 2013 10:01 AM Joey5105 Algebra 15 December 2nd, 2008 05:15 PM RickOShay Algebra 0 December 31st, 1969 04:00 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top