25May/09Off
excel function: inet_aton
inet_aton() converts the Internet host address cp from the standard numbers-and-dots notation into binary data and stores it in the structure that inp points to. inet_aton returns nonzero if the address is valid, zero if not.
Let say for ip A.B.C.D, the formula is :
ip = ((A*256+B)*256+C)*256
For example, if you have an ip of 74.125.45.100 (google.com), the formula would give a result of :
ip = ((74*256+125)*256+45)*256 = 1249717504