Finding the next real number in a series

I am trying to write an 'IF" statement that allows me to set N/As within my spreadsheet at the next real number values in order to obtain a continuous string of numbers. As I have a lot of values to convert I would really like to find a code that allows me to set the [if value is fals] as the previous real number.....Is this even possible?

Example of spread sheet and If statement (The code works fine, but when you have multiple N/As back to back it does not work):

A C
45.6833761
45.6825066
N/A =IF(A3="N/A",A2,A3)
N/A
45.6867965
45.6868034
45.6869954
N/A
N/A
N/A


Any help would be appreciated!!

S.

I see how it may work if A1 stayed constant, but the values in the A columns are changing

If I want A10 = the value in A7 (as it is the next real number)

The IF(A8="N/A",A7,A8) works if there the value above A8 is a real number but if it is an N/A (like in A9) then it reverts back to N/A.

so I guess I am wondering if there is a function that I can put into the IF statement that sets the [If_value_false] to a real number...so something like IF(A8="N/A",A7,|x|)