cash

  1. V

    PV and Interest Calculation Help

    Hello, A spreadsheet I recently inherited has hard coded numbers, I was hoping someone could help me with the formulas to recompute a couple columns (PV Cash & Interest Exp) that I can't seem to re-create. Discount rate is 10%, term is 1/1/2020 - 12/31/2020, it's on a 13 period fiscal year...
  2. M

    Return an amount with a criteria

    Hello everyone and please pay a smile when you work this because it's a pain... I have a table and I'd like to return an amount based on criteria. Let me explain below: <tbody> Financial Figures (SR'000) Salama Yearly Change(%) Cash & Cash Equivalents 2013 Insurance...
  3. M

    "Trying to return text for corresponding number"

    Hello Guys and smile where ever you be... I have a table (below) and trying to find the LARGER number (in a separate cell) which is ok with me. However, I'd like to return the text which is particular to that number. Let me illustrate more: <tbody> Company Cash on hand and at banks Term...
  4. C

    I need modifications in my macro to copy the cell values containing a particular substring and the values against those cells in the third right colum

    I have an excel file having nine sheets. Each sheet is having different tables. I need a macro to copy the cell values containing a particular substring and the values against those cells in the third right column and paste the same in two specific columns of excel sheet of a different excel...
  5. D

    Combo Column/Line graph formatting

    Hi all, What I have is a relatively simple data set. I'd like to graph it so that the Revenue entries appear as clustered columns, and the Cash entries appear as markers right above (or inside) the corresponding revenue column. Using a combo graph, I'm able to get the columns and markers to...
  6. Outdoorsman80

    Budget calculator for Excel?

    Hi, I'm trying to get my head around building this into our finances sheet and not sure where to start. What I want to do is have something like this https://www.calculators.org/budget/ - I want to specify a accounts with percentages and want to specify say a surplus of cash, and then divide...
  7. Z

    Dynamic XIRR Function -- I'm Lost

    Hello, I have a series of cash outflows and inflows over 144 months. The first 24 months are cash outflows - the next 120 month cash inflows. My sheet is set up as follows Row 1 - Numbered 1-144 Row 2 - Months (Beginning 8/1/18 thru 144 months) Row 3 - Cash flows Currently my sheet calculates...
  8. N

    Sum(vlookup)

    What is the easiest way to sum all "GL No" from 1000-1099 in range A2:D9 relating to cash in Table 1 and place total into cell A2 in Table 2? ...2200-2299 in "Inventory" on Table 2 and 5000-5099 in "Payable" on Table 2 . I have created a helper column but there must be a better way.....any...
  9. P

    Drop Down List

    Hi all, I would like to create a Drop Down List in cell “A1”, so that to choose any month and then to appear the data in the current Spreadsheet. Note that the months are belong to another file, named Cash Sales Table. In sch. 1. are the original data and in sch. 2. Is the expected result...
  10. N

    Find value and then reference cell 2 above

    Good afternoon, Sorry if this is repeated by I'm not even sure how to work this. I have a call that has the value "Total Cash". I am using this to find the cell. I can also use find and replace. Cells.Find(What:="TOTAL CASH", After:=ActiveCell, LookIn:=xlFormulas, _...
  11. H

    IRR Query

    Hi, I have an IRR related query, which I am struggling to resolve, any advice would be most appreciated. <tbody> 30/04/2018 0 31/05/2018 0 30/06/2018 -100 31/07/2018 0 31/08/2018 200 30/09/2018 20 31/10/2018 20 30/11/2018 10 </tbody> I am trying to calculate the IRR of the...
  12. M

    Calculating Drop For A Restaurant In Excel

    Hello everyone, I have a very specific excel question in regards to calculating the daily cash drop for a restaurant. Every day at my restaurant we start with $300 in the cash drawer across all amounts of change and bills. At the end of the day, the person closing counts the total amount of...
  13. R

    How do I return a value....

    ...based on a date that falls between two given dates. For example, I collected $100 on April 15 and another $200 on April 20. I need a formula that sums up all cash received in April between April 1 and April 30. Thanks!
  14. P

    VBA Virtual Loop

    Hello, How do I write code to move on to another question if the information doesn't exist on my spreadsheet? My code is: 'Select Start of range Range("B1").Select While ActiveCell.Value <> "" 'This writes 'Cash' in column A against cash transactions. If ActiveCell.Value <> "" Then...
  15. C

    Dynamic Periods NPV

    Is it possible to calculate a Future Value that has an NPV of 0 without using goal seek or VBA? I have an investment in stock quantity (D3) and price (D4) to calculate a cash outflow (D5). I have a return rate (D8) of 10% and a holding period (D7) in months and there are no other cash inflows...
  16. P

    VBA Coding between the lines!

    Hello, How do I write a code to highlight everything, including the blank lines? I need to highlight and copy everything in B1:E7, and I seem to be stuck at just highlighting B1:E2. ActiveCell.CurrentRegion.Select isn't giving me much joy. I'm stuck in a virtual loop! Thanks for your help...
  17. P

    IF formula imbedded with concatenation

    Hello, How do I write a formula to: 1. Determine if a cell is labelled "Cash", "Cheque" or "EFT" 2. If it is then I need to concatenate certain cells together. Example: Thanks for your help. Best wishes, Peggy <tbody> A B C D E F 1 Cash Stationery {formula = }Cash - Stationery 2...
  18. M

    Formulas to CountIF? & SUM

    Hello everyone! I am in need of two formulas that could possibly be the same/similar. See sample tables below: <tbody> Name Title Hours Helper Column? June Carter Cash Singer 1.33 1.83 June Carter Cash Manager 1.67 1.67 Hank Williams Singer .20 .70 Hank Williams Songwriter 1.50 4...
  19. H

    URGENT: Suming numbers until a certain point

    Hi, I am trying to create a formula, that when the trigger in column C is met (1 being trigger met), takes the cash going forward in column A to column D, until the point that the sum of the cash in column D equals % of the cumulative cash at the trigger point. For example, the trigger hits...
  20. N

    Please help

    Hi everyone, I am happy to join to such wonderful forum. I will really appropriated if you could help this issue. I have the following table <colgroup><col></colgroup><tbody> <tbody> Day Amount Means 1 143 Bank 2 22 Cash 3 1980 <tbody> Master Card </tbody> 4 5 Debt Card 5 388...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top