title: Excel hardcode, subnet value that increments
body: <p>im currently trying to figure and formula that can help me.</p>
  
  <p>I want to receive a subnet from a costumer Ex(100.100.100.0 or 10.200.200.20)</p>
  
  <p>And incremente based on the value given.</p>
  
  <p>So in the first row it will always be the value given +1 (100.100.100.1 or 10.200.200.21).
  Second row  the value given +2 (100.100.100.2 or 10.200.200.22)</p>
  
  <p>And so on.
  Last one base value +14(100.100.100.14 or 10.200.200.34)</p>
  
  <p>I wanted this hardcoded(no macro) for the excell sheet , and only change the last octet. Im havig ptrouble as the string size can chage.
  This is used to devide the ip in a /28 subnet.</p>