Somewhere in Range i5:i1000 there might be a cell with value under zero
In cell i3 I'd like a formula showing address of such cell, but if none then word NONE
Better yet, In cell i3 I'd like a formula returning a hyperlink to such cell showing it's address, but if none then word NONE
Struggling with getting address of such cell, with following formulas:
=IF(COUNTIF(I5:I1000,"<0"),CELL("address"),"no deductions")
=CELL("address",INDEX(I5:I1000,MATCH("-",I5:I1000,0),1))
=CELL("address",INDEX(I5:I1000,MATCH(COUNTIF(I5:I1000,"<0"),I5:I1000,0),1))