Hello,

I have a column of numbers in column C on sheet1.

I display the values in that column in column C on sheet2.
Some rows contain "#N/A" instead of numbers.

In column D on sheet 2, I would like to divide the numbers in consequtive
rows by each other. For example, if Column C didn't have "#N/A", then
D5=(C5/C4).

Suppose "#N/A" are present:
If C5 is "N/A", then I need D5="".
Otherwise,
if C4 contains "#N/A", then I need D5=(C5/C3).
If both C4 and C3 are "N/A", then D5=(C5/C2).
If more than 2 rows above C5 contain "N/A", then I would like D5 to be blank.

What should I do?
I tried using the formula
D391=IF(C3910,IF(C3900,((C391-C390)/C390)),IF(C3890,((C391-C389)/C389),IF(C3880,((C391-C388)/C388),IF(C3870,((C391-C387)/C387),""))))

but in this case, #N/A is displayed in cell D391...


Thank you for your kind help!