threshold

Hi, I am attempting to use a Sumproduct Froumla to work out commission but it isn't quite working. The below is what I am attempting. <colgroup><col><col><col><col></colgroup><tbody> Profit 1000 Starters 1 Actual starters 16 16000 Commision: 3194.8...

Hi all I am looking for a formula that is going to count all of the consecutive months equal to or over a set threshold (in this case the threshold is $10). The goal of this project is to count how long capital is invested in a project before it is paid back. My problem arises in accounts such...

Hello Hoping someone can help me come up with a formula for the column Discrepancy Under Threshold or confirm it's not even possible. I have been trying to come up with one but struggling. A simplified table is below. Logic explained in words of what I need: If Dropdown Category cell does not...

Hi I have a 2000 rows of numbers in column A. I need a formula to be written that when a number in ColumnA is >= '20', it will then mean the next 200 rows of data and display the mean number in Cell, B1. If has to be the first row which is greater than 20. Thanks in advance, Pedro

Hi All, I have a challenging formula I am trying to create. It essentially incorporates a threshold on profitability. Below I've laid out a simplified version of the data I am working with to help illustrate my problem. <colgroup><col><col span="2"><col><col span="6"></colgroup><tbody>...

Hi - I'm trying to build an output model similar to the one shown below, please see the following explanations to help answer: Main Issues: (I) When a unique ID has multiple transaction with a selected product code input before meeting the selected threshold amount. (II) Once threshold is met...

My objective is to establish a conditional format across the table based on a certain threshold establish for multiple categories. Each category will have a different threshold, which adds another layer of complexity to the issue. Below is an example breaking it down. Feel free to ask what ever...

Hi I want to calculate drawdown so that I am in a position to ascertain if the following statements are correct: SPX For the period 1900 – 2010, 5% corrections occurred three times per year on average, 10% corrections occurred once per year on average, and 20% corrections occurred once every...

I'm interested in recreating this table which shows the percentage cut off (or threshold) to earn shares (based on the size of the share pool) based off of volume of sales. The left side of the chart shows the number of shares available to earn. The top row shows the number of shares won. There...

I have a report that I'm responsible for managing that comes in weekly from several different members of my organization. They are sending certain statistics on each facility of our organization, which I then copy into a tab for the week in a master file and use the information reported by each...

Hi All, this is the first time I'm on this forum - I apologize in advance if my question isn't as detailed as it should be. Anyway, I was hoping someone could point me in the right direction for a macro I am trying to create. I have a set of data that is as following: in Column A I have a list...

Hi everyone, Quick one I just can't get right I am after a formula that will return the MAX value below a threshold. I have a list of numbers between 0 and 19000 I would like to determine the value that is the highest below 16000. I guess the second thing is a conditional format that...

I am trying to write a formula to calculate commissions. Employees collect 60% of sales up to a $25,000 threshold. After the $25,000 has been paid they collect 100% I am having a hard time getting Excel to calculate the sale at the point they cross the threshold and still accuratly calculate...