View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jewell jewell is offline
external usenet poster
 
Posts: 5
Default 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?