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(C391>0,IF(C390>0,((C391-C390)/C390)),IF(C389>0,((C391-C389)/C389),IF(C388>0,((C391-C388)/C388),IF(C387>0,((C391-C387)/C387),""))))
but in this case, #N/A is displayed in cell D391...
Thank you for your kind help!
Bookmarks