Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am trying to set up a formula to show a subsequent IP Address.
I am trying to set up a formula where i can enter an IP address and have that
the cell below that shows that IP adress + 1. The problem is the decimal points in the 1 st ip address. It's causing a value error. Any idea how to do what i'm attempting? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am trying to set up a formula to show a subsequent IP Address.
jewell wrote:
I am trying to set up a formula where i can enter an IP address and have that the cell below that shows that IP adress + 1. The problem is the decimal points in the 1 st ip address. It's causing a value error. Any idea how to do what i'm attempting? With no error checking for valid IP addresses: =LEFT(SUBSTITUTE(A1,".","*",3),FIND("*",SUBSTITUTE (A1,".","*",3))-1)& "."&TRIM(RIGHT(SUBSTITUTE(A1,".",REPT(" ",9)),9))+1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am trying to set up a formula to show a subsequent IP Address.
jewell wrote:
I am trying to set up a formula where i can enter an IP address and have that the cell below that shows that IP adress + 1. The problem is the decimal points in the 1 st ip address. It's causing a value error. Any idea how to do what i'm attempting? Shortened version: =LEFT(A1,FIND("*",SUBSTITUTE(A1,".","*",3))-1)&"."& TRIM(RIGHT(SUBSTITUTE(A1,".",REPT(" ",9)),9))+1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am trying to set up a formula to show a subsequent IP Address.
Please show us what you have and what you want with an example. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "jewell" wrote: I am trying to set up a formula where i can enter an IP address and have that the cell below that shows that IP adress + 1. The problem is the decimal points in the 1 st ip address. It's causing a value error. Any idea how to do what i'm attempting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Excel address book to Word for subsequent use with MSN Hotmai | Excel Discussion (Misc queries) | |||
copy formula into the subsequent cells, not contents | Excel Discussion (Misc queries) | |||
use row numbers from a list in subsequent formula | Excel Discussion (Misc queries) | |||
Formula that will change subsequent cells in a column to match fir | Excel Discussion (Misc queries) | |||
How can I use a time difference in a subsequent formula in Excel? | Excel Worksheet Functions |