I am trying to display the number in the cell above the row of percentages that 1st hit above a particular percent.
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
If I want to see the first time the percent is above 1.50%, how do I do this? The result of the formula should be 4 in this example.
Thank you
1 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 |
1.05% | (1.01%) | 0.90% | (0.85%) | 1.30% | (0.75%) | 1.62% | (0.38%) | 1.75% | (0.47%) |
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
If I want to see the first time the percent is above 1.50%, how do I do this? The result of the formula should be 4 in this example.
Thank you