Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AR Aging Report Design Issue | Excel Discussion (Misc queries) | |||
Aging Report | Excel Discussion (Misc queries) | |||
Organization of Aging Report | Excel Discussion (Misc queries) | |||
creating an aging report | Excel Worksheet Functions | |||
Help with Aging Report | Excel Worksheet Functions |