$100

  1. M

    DAX formula for accruals

    I need a correct formula for calculating accruals and I hope a finance type has something ready-made as this ties me in knots. (I think everyone hates accrual accounting.) We calculate accruals in a somewhat normal accounting way. If I order a $100 widget from Zimmer, we put it on a...
  2. M

    Which histogram formula is correct?

    Poking around on the web I find various formulas for creating histograms. I'm getting different results for each formula and I want to know which one is accurate. I have a table of purchase orders and I want to get the distribution of how many POs are in various dollar ranges (e.g. how many...
  3. C

    Auto Calculate Amount Remaining

    <tbody> A B C D E F G H 1 Debt Payment Due Jun Jul Aug Sep Oct 2 Loan $75 1st Y 3 CC1 $25 4th Y 4 CC2 $25 10th Y 5 CC3 $30 15th 6 Internet $75 20th 7 Cell $100 21st Y 8 Ins $100 24th 9 Car $350...
  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. U

    Compound Multiplication Problem

    My brain's gone blank for some reason. Say I have $100 in cell A1. And then I have -10% in cells A2, A3, A4, and A5. I want to know what happens if I take 10% off the $100 ($90)...and 10% off of that ($81), and so forth so I end up with $65.61 after taking four 10%s off. I can keep a running...
  6. U

    Dumb easy multiplication question

    My brain's gone blank for some reason. Say I have $100 in cell A1. And then I have -10% in cells A2, A3, A4, and A5. I want to know what happens if I take 10% off the $100 ($90)...and 10% off of that ($81), and so forth so I end up with $65.61 after taking four 10%s off. I can keep a running...
  7. R

    Stacked Bar Chart Comparison

    Sorry, not sure how to word exactly what I'm looking for, and Google has not returned what I need. I have a data set with results from 3 divisions (A,B,C). I'd like to create a bar chart the stacks quarterly results from A and B and displays them next to C. i.e. in Quarter 1 A had $40 million...
  8. S

    Formula Recommendation

    I have referred to a number of your videos and your advice has helped me immensely. Can you please proved a recommendation for me? I am putting together an order form and to set up the shipping and handling. Here are the guidelines: <colgroup class=""><col width="101" class="" style="width...
  9. Z

    Record cell value before update

    I have a sheet that gets updated by a pivot table. What I'd like to do is record the previous cell value before it updates. So say in range B3:H109 are dollar values. Lets just say cell B3 has a value of $100. When the sheet gets updated cell B3 now has a value of $150. I'd like to be able...
  10. V

    Formula to count a specific value within a range of cells in a table

    Okay, so I have a table with the following sample info. In column A I have an ID. There could be multiple duplicates or there could just be one. These IDs will run from cell A5 to probably no more than A10000. I have another column for a fee that is charged to each ID. If there are...
  11. A

    Help with this FORMULA PLZZZ

    Column C1= $125, $100 or $75 AND D1 = TRUE then this cell = A1, if not then it is blank. But also if column C1 = $50 and D1 = TRUE then this cell = B1. Not sure how to get this formula to work:confused: <tbody> Away Home $50 TRUE Home Away Home $75 TRUE Away Away Home $100 TRUE Away...
  12. F

    Find unique values with multiple conditions

    I've seen various q+a around this topic but can't get any of the suggested answers to work. I need help crafting a formula to find the number of unique companies that are both Special per column B and have an Investment Date in column C. I'm able to calculate the total of 5 Special companies...
  13. G

    sum product or sum if

    A B C D E 1 $100 Yes Matt 5/10/18 2 $200 1/10/18 Jim 5/10/18 Sum A, IF B = Yes C= is blank If B is "yes" and C is blank/ empty, then D= Matt E= Month, May (Month=5) In this instance, the answer would be $100...
  14. M

    Disconnected table measure not grouping as expected

    I would like help discovering why a disconnected slicer is not returning the expected data. Hopefully I’m missing something obvious. I would like to return a payment schedule based on our Accounts Payable (AP) groupings. The days to pay bucket is the Payment Date (if one exists) - Accounting...
  15. N

    IF condition with multiple criteria

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /></colgroup><thead><tr style="...
  16. Z

    VBA Macro for Userform

    I have an excel workbook that I have made a userform for. My plan for this form is to have the user pick a location from the first combo box and pick another location from the second combo box. After picking these two locations the user will click the run button to run the macro. Example of...
  17. K

    VBA help.

    Hi, I’m trying to create/find a code that will help me populate my spreadsheet, I have a maintenance spreadsheet that I need to enter new works into. For example, I need to visit one address, 8 x for $100 for 0-2 months, than I will need to visit 16 x $100 for 3-6 months and so on, so I’m after...
  18. E

    Formula to calculate the break-even ($0) at month's end

    I need to be able to calculate the break-even ($0) at month's end. The problem is that as Gross Revenue increases, Parts Cost increases..... <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 71px"><col...

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