$100

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Book1AB1RevenueComment2100$100 mm375$75mm - $99mm450$50mm - $74mm545$15mm - $49mm610$0mm - $14mmNested IF column A has numbers and column B is the final comment i am looking to capture based on the below criteria. For example if the number in column A is (>= 100) greater than and equals to 100...

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

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

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