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

Excel can solve equations through several of its mathematical functions, but the single Excel tool that works on the largest variety of equations is the program's Solver Add-in.