Payback Period
In my file, how should I adjust my payback period formula so it "always correct", in that it always uses the correct formula as in the year it is not negative for the cumulative cash flow row? Is there anything else incorrect in my other financial ratios? I need a sanity check on NPV, IRR, ROI as well. The current formula for Payback is: INT(C3+ABS(C36/D34))&" Years and "&ROUND(C3+ABS(C36/D34)*12;0)&" Months" NPV: SUMPRODUCT(C34:G34;C39:G39)+B34 IRR: IFERROR(IRR(B34:G34);"N/A") ROI: IFERROR((SUM(B23:G23)+SUM(B32:G32))/-SUM(B32:G32);"N/A") Many thanks in advance!
Spreadsheet views on Co-authored Spreadsheets
Me and my colleagues have a shared spreadsheet which is co-authored, we have an account handler column which we can filter by our own initials to be able to view just our clients on the spreadsheet. The issue I'm having is often the default view is changing to a view with just one of my colleagues with the initials SD showing for all the rest of us. Would anyone know how to stop this happening, I have had this issue for months. Kind Regards
Categorization based on an item type
Hello! Bear with me while I try to describe my dilemma. I am trying to group similar items and put them under umbrella terms. For example, in my sheet I have noted various rooms and the items contained in those rooms. Some rooms have similar items, others do not. I would like to reference a cell (For example, B2) and check if it is considered a "Toy", "Food", or "Clothing" item. Once it has identified it, I would like it to automatically print the associated category in A2. Once completed, I want to create a pivot table that neatly displays the total amount of Toys, Food, and Clothing items throughout the building. Rather than formulate a large if statement, would there be another formula or process that would allow me to do it faster? Thank you for your time!
Running Totals
I have two issues I'm trying to sort out. We are a non-profit organization required to keep track of grant monies. I have a spreadsheet that is keeping good track of expenditures, however... I need to create two columns that keeps a running total of total monies spent and balance remaining. In addition to that, I have two columns that keep track of mileage I also need to keep track of the accumulated mileage expense that I can easily restart upon payments made. I know these should be simple formulas, however as yet I've had to continually recreate the wheel in my spreadsheets. If anyone could please help, I will appreciate it.Consolidate/Merge Data in Multiple Files
I have two spreadsheets - both are lists of items with a tag number, serial number, item description, and comments (among other categories). On one of the spreadsheets, the comments column is completed but it is empty in the other spreadsheet. How can I add the comments from the spreadsheet that has them to the one that doesn't, based on what the tag number of each item is? Both spreadsheets are in a different order and some of the inventory items we have on one list do not match the other list, either because they are new inventory items or they were removed from inventory.Switch Panes Using F6 not working
I am using split panes to type a formula and I want to reference something from the top of the worksheet. When I press F6 to send me to the top pane, instead, it is sending me to the bar on the bottom of excel and the top ribbon. It is so frustrating because this worked for me before and now it is not working and is slowing me down greatly. I was wondering if anyone could help? Thank you.Payback Period
In my file, how should I adjust my payback period formula so it "always correct", in that it always uses the correct formula as in the year it is not negative for the cumulative cash flow row? Is there anything else incorrect in my other financial ratios? I need a sanity check on NPV, IRR, ROI as well. The current formula for Payback is: INT(C3+ABS(C36/D34))&" Years and "&ROUND(C3+ABS(C36/D34)*12;0)&" Months" NPV: SUMPRODUCT(C34:G34;C39:G39)+B34 IRR: IFERROR(IRR(B34:G34);"N/A") ROI: IFERROR((SUM(B23:G23)+SUM(B32:G32))/-SUM(B32:G32);"N/A") Many thanks in advance!
Word.FieldType.ref support on Word Online
I have an issue in a Word Add-in on Word Online where I'm trying to insert a reference field in insertField method of Range. I have the same function on Word on Windows, Mac, and Onlineso I need the same result on each environment. insertField(Word.InsertLocation.end, Word.FieldType.ref, `${bookmarkName} \\w \\h \\t`, true); I know that Word.FieldType.ref is not supported on Word on Web, but I wanted to ask if there's any ETA on when it will be available or if there's any workaround to achieve the same result as in Desktop?
