formula | PeteNetLive

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 items to price – then Excel is the way to go.

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

So simply change the figures in red below, drop the formula into a cell on your spreadsheet then use the auto fill option.

Excel IP Addresses Increment the First Octet

[box]
=””&ROWS($A$1:A10)&”.1.1.0“[/box]

Excel IP Addresses Increment the Second Octet

[box] =”10.“&ROWS($A$1:A1)&”.1.1“[/box]

Excel IP Addresses Increment the Third Octet

[box] =”10.1.“&ROWS($A$1:A1)&”.1“[/box]

Excel IP Addresses Increment the Fourth Octet

[box] =”10.1.1.“&ROWS($A$1:A1)[/box]

PeteNetLive

Technology that 'Just Works'

Tag Archives: formula

Excel: Calculate Cost, Margin, Sell Price

Problem

Solution: Working out the Sell Price

Solution: Working out the Cost Price

Related Articles, References, Credits, or External Links

Excel – IP Address Formula for ‘Auto fill’

Problem

Solution

Excel IP Addresses Increment the First Octet

Excel IP Addresses Increment the Second Octet

Excel IP Addresses Increment the Third Octet

Excel IP Addresses Increment the Fourth Octet

Related Articles, References, Credits, or External Links