I am trying to come up a formula that will look across a row to
1.) see if the cell in N for that row is empty and
2.) if it is empty to look at the date in colum g and
3.)if the date is more than 30, 31-60, etc days past today return the amount
in H to the corresponding cell in J.
Currently, if I enter the formula on each row I am able to display the
correct information but I am hoping to be able to come up with a way to just
have to enter one formula for the entire column. There will be information
added to the worksheet and as cells are populated in column N it will change
the later aging.

Any help is greatly appreciated

Becky


G H I J K
L N
Due Date Amt Current 30 31-60 61-90
Paid Date
2/8/2009 154.00 154.00
2/9/2009 1427.95 1427.95
3/16/2009
2/18/2009 100.00 100.00
5/1/2009