$200

  1. S

    Determine the oldest date of debit transaction in account, that hasn't been summed to 0 yet

    <tbody> User ID Amounts Posting Date 11 $500 2017.07.24 11 -$150 2019.04.05 11 -$200 2019.05.10 11 $200 2019.06.24 11 -$350 2019.06.25 11 $600 2019.09.03 11 -$100 2019.09.07 11 -$200 2019.10.03 </tbody> I there a way in which I could automatically...
  2. 2

    Last cell on column graph

    Hi there, just wondering if a column on a graph can be made to change as different cells are chosen. As an example, Column c, cell C2 is $400. The graph shows $400. If i take $200 from the total, Column c, cell C3 becomes $200. I would like the graph to now show the new balance from C3 instead...
  3. J

    Columns on a graph

    Hi there, just wondering if a column on a graph can be made to change as different cells are chosen. As an example, Column c, cell C2 is $400. The graph shows $400. If i take $200 from the total, Column c, cell C3 becomes $200. I would like the graph to now show the new balance from C3 instead...
  4. M

    Count Unique Values That Meet Criteria

    I am attempting to count the unique values in one column where a criteria is met in another column. (Assume the following data starts in cell A1.) I want to count the number of different Names in Office 1. (The answer is 3: Joe, Lisa and Betty.) I don't think the COUNTIFS function will work...
  5. C

    Sliding Retention calculation

    Hi I'm trying to create the following formula for a sliding retention calculation based on an invoice amount as follows:- 1. If the current amount invoiced is less than $200,000 retention value is 10% 2. If the current amount invoiced is between $200,000 and $800,000 the retention value is...
  6. A

    Sliding scale commission formula

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

    Formulas in a Measure

    I am trying to make a measure that combines a starting budget and a revised budget to create a final budget. As an example of what I am looking for, some line items have a starting budget (say $200) and no revised budget ($0), so the final budget would be $200. Some line items had a starting...
  8. S

    Tier Calculation on Sales Commission - Accumulative on Payout Rate

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

    Bell curves for housing prices

    Hello Excel users! In short, I'm trying to create a bell curve to show low-end and high-end housing prices that I can afford based on a budget and the curve can adjust according to income. Before I go into detail, may I say that I'm brand new to this site and this is my first question to post...
  10. F

    Financial Planning

    I am working on a 30-year plan. I want to have a row of years and the amount that would have to be put away each year. Lets say we had a $200,000 project that we wanted to do in year 2025 and we wanted to save for 3 years. 2019 would be 0, 2020 would be 0, 2021 would be 0 , 2022 would be one...
  11. A

    Sort entire Rows to different tabs based on one cell of information.

    Hello, I need to create a sheet that that will have a general tab for entry, but it would then sort and send an entire row of data to another tab based on the information of one cell. I realize that it is close to a vlookup, but don't know how to make a vlookup to apply to the entire row (not...
  12. J

    Sales Tracker Questions on Combining Figures

    <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>I want to make a formula that changes the value of cars 1-14 to 250 when a person inputs a Vehicle in cell 15. I want the payout to calulate the total as cars get put into the vechicle cells. (Line 1 payout would be 200...

Some videos you may like

This Week's Hot Topics

Top