Excel formula stopped working
I have a work book with 6 sheets in it, tracking grain sales. Two sheets have stopped calculating the formula the more lines we use. I have to drag it across the cells to get it to calculate all of a sudden instead of it auto-calculating. Im not sure if its a rounding issue that causes it to stop working? I was told previously that this has happened and thats what they thought it was, but the girl at my work that created the spreadsheet, is no longer here. My boss doesnt remember how to fix it. Any ideas?An unhelpful Error Message
This is for the Microsoft folks who monitor this forum. I was attempting to respond to a question a few minutes ago and got the error message that appears at the bottom of this image. Note: I had not added any HTML myself. I had copied and pasted the items in the bulleted list, so it's possible that something carried over from Google...but in either case, that message -- how should I say it? -- contains invalid tech-speak. I was able to post the reply by eliminating the bullets, but those bullets had been added by, you guessed it, the forum's own software. Does the TechCommunity's left hand know what the TechCommunity's right hand is doing?I need to learn how to use the LET function in Excel...
Hello Excellers, I am using a complex If statement to figure out if a machine is ready to receive work. I need to check if the machine is online, or broken down, or off line for some reason or another, Has a Human worker to work on the machine, and on and on... I am thinking would a LET function help in making the IF function more accurate, and less complicated? I have not worked with the LET function, and I think I would like to learn about it. Any nice resources for examples and tutorials? Thanks in Advance! GiGi!As any one found cool icons to use on a Custom Ribbon?
Hello Excellers, I just finished making a neat custom ribbon for an application, and I am wondering if anyone has found a cool and neat place to grab some icons for the button faces specially if in color. My ribbon looks nice, and most importantly it works as intended, but I am kind of thinking it could be more colorful. So far I only used the built-in stuff. Thanks for any hints. GiGi
Suggestion: Add =IMAGE() function to Excel 2016 & 2019
Hi Microsoft Team, I’m an Excel 2016 user and really appreciate the product. However, I’ve noticed that the =IMAGE() function is available only in Microsoft 365 and the web version. Many of us who are using perpetual versions (Excel 2016 / 2019) would love to see this function back-ported. It’s a small but powerful feature that makes dashboards, catalogs, and reports much more useful. Not everyone can move to 365, but we still look up to Excel for improvements. Adding =IMAGE() to 2016 and 2019 via update would make these versions more practical and user-friendly. Please consider including this in a future update. Thanks for listening and for continuing to improve Excel!How to Be an Excel Detective: Finding and Highlighting Formulas
Hi everyone, I recently wrote a blog post on some simple, yet powerful, techniques for anyone who works with Excel spreadsheets, especially those with complex data. I wanted to share a summary of it with this community, as it might be helpful to others who are looking to understand and protect their work. The post covers two main things: Quickly Revealing All Formulas: A simple keyboard shortcut (Ctrl + `) or the "Show Formulas" option can instantly reveal all formulas in a worksheet. This is a great way to quickly see how a spreadsheet is structured. Permanently Highlighting Formulas: The article shows how to use the "Find & Select" > "Formulas" feature to select all cells containing formulas and then permanently highlight them with a fill color. This visual cue can help prevent accidental edits and protect your data. Watch This in Action: For a step-by-step guide on how to use these techniques, you can watch the video on my https://www.youtube.com/@BIGurus. 🔗 https://youtu.be/1x-1dbqlWXk You can also read the full article here: https://medium.com/@anandsharad/how-to-be-an-excel-detective-finding-and-highlighting-formulas-fe9d4fdbc1b1 I'd be happy to answer any questions you have or discuss other Excel tips and tricks in the comments!
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!
