There is a list of numbers given to me in Excel: 0,1,3,5,7,2,4,6,8,10.
A list of such numbers should follow an increasing ordinality. So the numbers following ordinality are: 0,1,3,5,7,8,10 and numbers that do not follow are 2,4,6. Now we have to replace 2,4,6 with equidistant numbers between the 2 numbers that followed ordinality, i.e. 7 and 8. Hence, 2,4,6 become 7.25, 7.5 and 7.75. How do we implement this logic in Excel using formulas, without using VBA?

I’m unable to move past the first step itself, that is finding the ordinality. I tried : =IF(AND(A2>A1,A2>A3),"Correct","Broken"). But this gives 7,2,10 as “Broken” which is not what is required.

The expected answer is 2,4,6 are “Broken”. And then they should be replaced with 7.25, 7.5 and 7.75.