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 SkipVought 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
0
0
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
139
sbcsu
sbcsu
coorsman
  • Locked
  • Question
Subnet question 1
Replies
1
Views
48
mltoombs
mltoombs
laketech
  • Locked
  • Question
subnet gateway?
Replies
1
Views
44
bnorton916
bnorton916
Randar162
  • Locked
  • Question
Access an IP on another subnet
Replies
1
Views
42
cisconooblet
cisconooblet
ingram87
  • Locked
  • Article
How to Remotely Set IP Address, Gateway, Subnet, or DNS Servers
Replies
0
Views
46
ingram87
ingram87

Part and Inventory Search

Sponsor

Back
Top