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...
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...