how to locate a field when field equals zero

[Sundance]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

is there a function or formula to use to locate a cell in a column when that cell is <= to zero, then be able to identify what row the cell that equals zero is located in?

for example--when my loan balance equals zero in F60, i want to have a different cell on my output page give me the corresponding pay period the balance is now zero. so column B is the pay period ascending, and column F is the loan balance descending.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

is there a function or formula to use to locate a cell in a column when that
cell is <= to zero, then be able to identify what row the cell that equals
zero is located in?

for example--when my loan balance equals zero in F60, i want to have a
different cell on my output page give me the corresponding pay period the
balance is now zero. so column B is the pay period ascending, and column F is
the loan balance descending.

One way (array-entered:CMD-RETURN):

=MATCH(1,IF(F1:F1000<=0,1),FALSE)