How can i add with IP Addresses......????

[JonesZoid]

Hi All,

I just wondered if it would be possible to add to an ip address.

e.g: In Cell A1 i have an ip address - 10.10.10.100
How would i add 2 to it - 10.10.10.102 and display it in A2
And vice versa - remove 1 from 10.10.10.103 and display it in A3

Your help is much appreciated.

Craig

[zbor]

Where is stored criteria how much to add: +2, -1...

[Special-K]

Try

=LEFT(A1,FIND(CHAR(7),SUBSTITUTE(A1,".",CHAR(7),3)))&RIGHT(A1,LEN(A1)-FIND(CHAR(7),SUBSTITUTE(A1,".",CHAR(7),3)))+2

Change the +2 to however much you want to offset it, +2 -1 etc

[JonesZoid]

Thanky you - works like a dream.....

Craig

[Pepe Le Mokko]

There is a small flaw, as the last bit may not exceed 255 so perhaps add =min(255,SPK formula)