Skip to content

Instantly share code, notes, and snippets.

View LewisKarkov's full-sized avatar

LewisKarkov

0 followers · 2 following
View GitHub Profile
@LewisKarkov
LewisKarkov / excel formulas.md
Created April 22, 2023 02:19 — forked from f-steff/excel formulas.md
Excel formulas to calculate IP values such as Netmask, IP range start, IP range end, Broadcast IP, Number of hosts.

Excel formulas to calculate IP values - Works in Excel and Google Sheet.

Updated March 16. 2023

Prerequisites:

  • A1 contains an IP address, such as 10.0.0.2
  • B1 contains the number of bits in the netmask (CIDR) such as 24

The below formulas then go into C1, D1 etc. to perform the various calculations. Some calculations depends on other calculations.