ABCDEFGHIJKLMNOPQRST
1
2
To get a copy of these functions, save a copy of this sheet, then go to Extensions->Apps Script.
3
4
For questions or help, contact: jemery27@gmail.com
5
6
Help Doc:IP Functions Help File
7
8
Excel version can be downloaded here:
https://www.dropbox.com/s/mv506odpyo3n8hn/IP%20Functions%20v1.2.zip?dl=0
9
10
11
1.2.3.34=IPNETWORK(A12)=IPBROADCAST(A12)=IPNEXTNET(A12)=IPADD(A12,2)=IPADDR(A12)IPFILL(A12)
12
5.6.7.0/285.6.7.05.6.7.155.6.7.16/285.6.7.25.6.7.05.6.7.0/28
13
1.2.3.4/245.6.7.1
14
5.6.7.2
15
=IPHOSTS(A12)=IPISIN("5.6.7.9",A12)=IPMASK(A12)=IPOCTET(A12,3)=IPVALID(A27)5.6.7.3
16
14TRUE255.255.255.2407TRUE5.6.7.4
17
5.6.7.5
18
=IPMASKWILD(A12)5.6.7.6
19
0.0.0.155.6.7.7
20
5.6.7.8
21
=IPMASKLEN(A11)5.6.7.9
22
325.6.7.10
23
5.6.7.115.6.7.8/27
24
5.6.7.12TRUE
25
5.6.7.13
26
DD2DECDD2BINDD2HEX5.6.7.14
27
1.2.3.4/248428108800000001000000100000001100000100010203045.6.7.15
28
29
DEC2DDBIN2DD
30
5.6.7.01.2.3.4
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100