$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

Top