# \$200

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