MS Office 365 ProPlus
Looking for help to create formula in Excel for below...
A /23 subnet being broken down. 255.255.254.0 (/23) User input data in cell C12 - ex. 10.203.4.0
Require formula in cell C13 to return value 10.203.4.1
255.255.254.0 (/23) Cell C13 - to data in C12 to fourth octet add 1.
Require formula in cell C14 to return value 10.203.220.16
255.255.255.240 (/28) Cell C14 - to data in C12 to third octet add 216 & to fourth octet add 16
Require formula in cell C15 to return value 10.203.220.17
255.255.255.240 (/28) Cell C15 - to data in C14 add 1 to fourth octet.
or
255.255.255.240 (/28) Cell C15 - to data in C12 to third octet add 216 & to fourth octet add 17
Require formula in cell C16 to return value 10.203.229.88
255.255.255.248 (/29) Cell C16 - to data in C12 to third octet add 225 & to fourth octet add 88.
Require formula in cell C17 to return value 10.203.229.92
255.255.255.248 (/29) Cell C17 - to data in C16 to fourth octet add 4.
or
255.255.255.248 (/29) Cell C17 - to data in C12 to third octet add 225 & to fourth octet add 92.
Require formula in cell C18 to return value 10.203.237.0
255.255.255.192 (/26) Cell C18 - to data in C12 to third octet add 233.
Require formula in cell C19 to return value 10.203.237.1
255.255.255.192 (/26) Cell C19 - to data in C18 to fourth octet add 1.
or
255.255.255.192 (/26) Cell C19 - to data in C12 to third octet add 233 & to fourth octet add 1.
Require formula in cell C20 to return value 10.203.6.0
255.255.255.248 (/29) Cell C20 - to data in C12 to third octet add 2.
Require formula in cell C21 to return value 10.203.6.1
255.255.255.248 (/29) Cell C21 - to data in C20 to fourth octet add 1.
or
255.255.255.248 (/29) Cell C21 - to data in C12 to third octet add 2 & to fourth octet add 1.
Formula to add to any octet any value with condition to check & verify no octet value is above 255 will be even more better.
Thank you
Bookmarks