How do create a formula to add IP addresses?

Posted to microsoft.public.excel.misc

jeffreyj

Posts: n/a

How do create a formula to add IP addresses?

I am trying to make a formula that adds the last part of an IP address, such
that when I type in one IP address suchas 147.202.70.132, they automatically
fill in below sequentially with 133, 134, 135, etc. Can anyone help me with
this? Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create reference formula that looks through all sheets for matchin	BMW	Excel Worksheet Functions	2	November 4th 05 04:20 PM
How do I create a 26 'tier' IF formula?	callum	Excel Discussion (Misc queries)	5	October 23rd 05 04:48 PM
How can I create a formula for Salutation	cs_vision	Excel Discussion (Misc queries)	6	October 8th 05 12:31 AM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
In two workbooks, how do I create a formula that will look at a o.	socaldave469	Excel Discussion (Misc queries)	1	April 22nd 05 10:01 PM

All times are GMT +1. The time now is 03:08 AM.

Menu

About Us