For example, to calculate the network address when a subnet address of 255.255.255.224 masks a host address of 192.168.1.161, type "192" into cell A1, "168" into A2, "1" into A3 and "161" into A4.

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 ...