Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Calculation | Excel Worksheet Functions | |||
Bad Calculation in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming |