Last seen: Jul 6, 2025
Hello, Just want to show you an alternative approach where there is no need to have extra sheets nor hiding them. You just need to organize your da...
Hello Dean, If you have Excel 2016 or newer you can use the IFS function. If you are using an older version then you can use nested IF function. ...
Hello, In case you have Excel 2016 or newer you can use IFS function.
Hello, For your second problem, check out these two examples.https://stackoverflow.com/questions/6312710/how-to-get-images-to-appear-in-excel-given...
Hello, The fees calculated with percentage, are they calculated on the base value only or with the fees and taxes added? Example: Base Premiu...
Hello Sara, It would be great if you can upload a sample file showing us the data and structure you have, it will be a lot easier for us to give yo...
Hello, This blog article by Mynda is perhaps presenting something similar of what you have in mind. /Anders
Here is a good list showing all Excel functions and from which version they are available.
Hello, With the current layout you can't avoid messy formulas, as you probably have guessed by now. As also already mentioned, I assume you will ha...
Hello, It has passed many years now since I worked with such financial data, so please correct me in case I am overlooking some aspects. Based on y...
Hello, The term ”break even” is for me how many units you need to sell to cover the costs. With this in mind you should use following formula: F...
Hello, Have you tried using the ISOWEEKNUM function?
Hello, I am not sure If this is the scenario you describe, but check this tip on how to ”reset” scroll bar in Excel. Br, Anders
Hello, Just a simple example attached where I am using VLOOKUP function. Check the highlighted cell. It is showing 96 but the underlaying value is ...
Hello, If you start Excel first and then when in the Open file view, choose the option to open and repair. But this is also no guarantee that it wi...