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.