Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel subnet formula

Status
Not open for further replies.
ermedic

ermedic

ISP
Dec 8, 2004
12
US
Does anyone know of an Excel formula I could use to calculate a range of IPs given an subnet ID and a subnet mask?

 
Sort by date Sort by votes
no... but there are free programs which do this for you..

such as SolarWinds Subnet Calculator.

Computer/Network Technician
CCNA
 
Upvote 0 Downvote
Yeah....those I have...but I am looking for a formula that I can put right in excel that would do it.
 
Upvote 0 Downvote
How about a program that runs thru javascript.
You can subnet based on number of subnets needed, or number of hosts needed per subnet.

accessuserva
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jmarkus
  • Locked
  • Question
Can I have a different private IP address which isn't on my router's subnet?
Replies
6
Views
328
sbcsu
sbcsu
coorsman
  • Locked
  • Question
Subnet question 1
Replies
1
Views
75
mltoombs
mltoombs
laketech
  • Locked
  • Question
subnet gateway?
Replies
1
Views
67
bnorton916
bnorton916
Randar162
  • Locked
  • Question
Access an IP on another subnet
Replies
1
Views
59
cisconooblet
cisconooblet
ingram87
  • Locked
  • Article
How to Remotely Set IP Address, Gateway, Subnet, or DNS Servers
Replies
0
Views
73
ingram87
ingram87

Part and Inventory Search

Sponsor

Back
Top