Inserting a value into a sequential series and then continuing the series <p>Example data series has the sequence seeded with 1 as the initial value, and a step of 1. There is a calculated value that needs to be inserted in the series, in this case it is 3.5</p> <p>Desired output:</p> <pre><code>1 2 3 3.5 4 5 </code></pre> <p>I am avoiding VBA, and I am avoiding sorts. I am trying to do this with an IF formula. </p> <p>So far I have tried the following A2 copied down:</p> <pre><code>=IF(A1+1&lt;3.5,A1+1,IF(A1&lt;&gt;3.5,3.5,A1+1)) </code></pre> <p>Seed value may be any real number. Step value may be any real number.</p>