tier

Trying to setup a spreadsheet to do this but here's the grid below. Bonuses are ONLY given on the amount between the threshold. For instance, if you do 500K of commission and fee's, you get a bonus on tier 1 on 99,999 of production, then you also get a bonus on the 299,999 of production. You...

Hello, I am trying to create a formula in a block of cells that would parse volume into tiers based on cumulative volume but only tier the monthly volume as follows... Month Jan Feb Mar Apr May Jun Volume 1000 2500 3005 4000 5000...

Hello, I have a situation that I'm looking for help on a formula that seems to be stumping me. The data that I'm working with are members accounts but what I'm specifically needing to pull is members money market accounts which would be referenced as Item #'s 7, 8, and 10. The two columns of...

when any cell changes in row C it emails me what was changed and what it is now. Is it possible to see the names as well in row A in the email when any cell is changed in C.. So if C-3 was changed I see the information for A3 and C3 in my email. This is what im using any help be appreciated...

Hello - I am trying to pivot the same data multiple times to understand the all sub-level components of my finished parts. I have a list of parent items and the items that make them up which looks like this: Parent Item (A) Component Item (B) I can pivot the parent to component to get all...

Shown data is a simplified example of a spreadsheet I'm trying to enhance at work, basically I already have a Pivot Table that automatically pulls data from another data source on daily basis which can change with new items being added or removed due to sales. To the right of this Pivot Table...

Hi all, I am not an advanced user of Excel by any means and am struggling to create a formula for calculating sliding scale sales commissions. I'm the manager of a real estate office and require a formula to assist with automatically calculating the commission payable to an agent based on their...

Good evening, I am having (a lot of) trouble attempting to put together a formula that properly calculates my organization's tiered bonus formula. Our managers are paid bonuses according to the following criteria: Goal: "X" units rented First Tier: 0-49.99% of goal reached, $0 (if you don't...

I've been looking through multiple posts and am familiar with utilizing SUMPRODUCT to calculate commission tiers that pay out different rates based on sales thresholds. As an example: Pay 10% from $0-$99; 15% from $100-$199; 20% from $200-$299 We have a new wrinkle in the comp plans this year...

I'm working to create an allocation model to quickly determine whether or not an order can be supported when compared to the available inventory. For example, I have 3 customers, each in their own tier (1,2,3). Tier 1 customers will have priority and first dibs at the available inventory, then...

Good morning gang. Hope you're all well. My question is around a worksheet I have like this: <tbody> Division Business Unit ID Owner Value Steam Tier Status Championship Delivery 1 14 John Smith Stream 4 Tier B Good Championship Delivery 1 14 John Smith Stream 2 Tier A Good Premier...

The green section of my formula is counting blanks as Tier 4 and some below the mark of Tier 1 are showing Tier 4. Can anyone see an obvious error i may be missing? =IF(AND($D5>=$N$6,$E5>=$N$7,$F5>=$N$8,$G8>=$N$9),"Tier 4",IF(AND($D5>=$M$6,$E5>=$M$7,$F5>=$M$8,$G5>=$M$9),"Tier...

Hi, I'd greatly appreciate help finding a formula that will calculate the figures in red (cells C3:F6) in my mockup below. Column I contains sales thresholds at which different bonuses are paid in 4 tiers labelled in Column H. If I sell 100 units in Quarter 1 (Cell B3), that would mean all of...

I am having issues creating this formula for a Projected Cash Flow Budget regarding the Commission Sales Payout. Here is the scenario as followed: The first $200,000 = 10% The second $200,000 = 8% Any sales dollar exceeding $400,000 = 7% Lets say our Sales guy sales $280,000 the first month...

Hi All, Currently I have 10K+ rows of data which increase every month that's why I need a vba code that will return "Tier 2" and "Tier 3" in column (D) Tier. Here are the conditions: 1) Tier 2, if there are 2 or more unique Order ID within the last 12 months per Account Name. (using Today()...

Hi All, Could you please help me in this? Currently I have 20K+ rows of data that's why I need a formula that will return "Tier 2" and "Tier 3" in column (D) Tier. here are the conditions: Tier 2, if there are 2 or more unique Order ID within the last 12 months per Account Name. Tier 3, if...

Hi, this may be a very basic question but hopefully that means there's an easy answer! I have a fixed budget (let's call it £10,000) and I have a set number of items that I have to sell. Different items are valued at different levels and I need to calculate a budget per item, using a consistent...

Hey Gang. I'm wondering what the most efficient approach would be On another sheet, I have a value I want to return the Account Tier Name based on what range that value falls between So let's say I have a cell that I enter the value $2,500 (Let's call that Cell A1) I need it to scan the below...

Hi All, I have to populate a 3x4 table that is a list of our corporate projects. The projects belong to only one Division and Tier at a time. Projects progress from Tier 3 to 2 to 1. The data is sorted like this: <tbody> Proj_Name Tier Division Project A 3 Operations Project B...

I've got a table with the following columns Quantity, Price, Sub Total, Discount Tier, Discount Amount, Total If the quantity is between 100 and 200 I want to show a 5% discount in the Discount Tier column If the quantity is between 201 and 300 I want to show a 7% discount in the Discount...