ip calculation using excel
 

I am a network engineer and I like to use excel to document my projects.
I would like to know if any one has some macros to deal with IP. It is
hard to believe that there is no logical operation OR,XOR... on excel
to deal with 1 and 0. I would like to be able to calculate hosts,
subnets, broadcast.... check ips....

I tried to do a search on the forum, but the limit of 4 characters is
weird. You can not just put ip.


Thanks


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

ip calculation using excel
 

myforum,

Search Google for "ip"
http://groups.google.com/groups?hl=e... ublic.excel.*

John

myforum wrote:

I am a network engineer and I like to use excel to document my projects.
I would like to know if any one has some macros to deal with IP. It is
hard to believe that there is no logical operation OR,XOR... on excel
to deal with 1 and 0. I would like to be able to calculate hosts,
subnets, broadcast.... check ips....

I tried to do a search on the forum, but the limit of 4 characters is
weird. You can not just put ip.

Thanks

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements