Can I do an IF function to find the value if it is greater than 0 in more than 8 rows?
| A | B
1 | 0 |
2 | 0 |
3 | 0 |
4 | 4 |
5 | 0 |
6 | 0 |
7 | 0 |
8 | 0 |
=IF(A1>0,A1,IF(A2>0,A2,IF(A3>0,A3,IF(A4>0,A4,IF(A5 >0,A5,IF(A6>0,A6,IF(A7>0,A7,IF(A8>0,A8))))))))
RESULT=4
But I got an error message after A9 or row9.
Any help would be appreciated.
Thanks.