Excel: Calculate Cost, Margin, Sell Price
KB ID 0001835 Problem Occasionally at work I need to work out what the sale price / retail price will be for something would be (given that I know the cost and the % margin). That’s easy to work out. But sometimes I get given the sell / retail price and I know the margin used, and I then must work out what the cost will be. Ordinarily if it’s a quick question I’ll just use and online margin calculator. But if I have a LOT of...
Microsoft Excel – SGXLADDIN.dll could not be found
KB ID 0000505 Problem Seen when launching Microsoft Excel.. Error: ‘C:WindowsSysWOW64SGXLADDIN.dll’ could not be found, Check the spelling of the file name, and verify that the file location is correct. Solution You are seeing this because you have installed a Sage accounting product in the past and it dropped some add-ins into Excel. 1. Close the error > Click File> Options > Add-Ins > Select the “Sage...
Excel – Creating a Dropdown Box ‘From data on another sheet’
KB ID 0000711 Problem My wife asked me how to do this today. I don’t use Excel much, most people think because I work in IT I know everything about all software packages, and they are surprised when I’m asked questions like this, and I say ‘I don’t know I’m a network engineer’. But seeing as it was for the better half, I fired up Excel and worked it out. (This must be worth at least a cup of Tea!)...
Excel – IP Address Formula for ‘Auto fill’
KB ID 0000928 Problem I got asked this week if I know how to do this, a colleague was doing a spreadsheet, and needed to quickly put in IP addresses. The Problem is if you use ‘Auto Fill’ to continue your IP addresses, it does not behave quite like you would expect. Solution A quick search got me most of the way there, but the solution is different depending on which ‘octet’ of the IP address you want to...