My Math Forum  

Go Back   My Math Forum > High School Math Forum > Algebra

Algebra Pre-Algebra and Basic Algebra Math Forum


Reply
 
LinkBack Thread Tools Display Modes
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.
rfhitter is offline  
 
September 8th, 2017, 02:02 PM   #2
Senior Member
 
romsek's Avatar
 
Joined: Sep 2015
From: Southern California, USA

Posts: 1,413
Thanks: 717

Quote:
Originally Posted by rfhitter View Post
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
romsek is offline  
September 8th, 2017, 02:05 PM   #3
Senior Member
 
romsek's Avatar
 
Joined: Sep 2015
From: Southern California, USA

Posts: 1,413
Thanks: 717

will you have a list of all orders?

I'm curious how we are supposed to compute the average sale if not.
romsek is offline  
September 8th, 2017, 03:22 PM   #4
Math Team
 
Joined: Oct 2011
From: Ottawa Ontario, Canada

Posts: 10,487
Thanks: 693

Quote:
Originally Posted by rfhitter View Post
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"?
Denis is online now  
Reply

  My Math Forum > High School Math Forum > Algebra

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 05:23 PM
Reverse compound interest excel formula? Apple30 Elementary Math 3 February 6th, 2015 12:48 AM
Excel Formula for Breakeven Interest Rate RickOShay Math Software 5 August 31st, 2013 10:01 AM
Excel Exponential or Logarithmic Formula Help Joey5105 Algebra 15 December 2nd, 2008 05:15 PM
Excel Formula for Breakeven Interest Rate RickOShay Algebra 0 December 31st, 1969 04:00 PM





Copyright © 2017 My Math Forum. All rights reserved.