threshold

  1. P

    If greater than a threshold, then average next 200 cells

    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
  2. H

    Challenging Formula: Please Help

    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>...
  3. P

    Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached.

    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...
  4. C

    Multiple Criteria Conditional Formatting with Threshold

    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...
  5. G

    Conditional Drawdown

    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...
  6. K

    Percentage thresholds table (How do I recreate this with formulas/excel?)

    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...
  7. J

    Return Value from one tab to cell on another tab based on threshold

    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...
  8. V

    Counting number of times a maximum exceeds a threshold on a certain frequency

    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...
  9. A

    Determine MAX below a threshold

    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...
  10. F

    HELP, Commission Scedule

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top