How to Calculate Subnets With Microsoft Excel. IP addresses on your company network consist of three parts: the network address, the host address and the subnet mask. The network address ...

I have an Excel spreadsheet containing IP addresses and subnet masks. I need to derive the subnet of each IP address in the spreadsheet.Example: IP (column A): 10.1.230.84, Subnet Mask (column B ...