Accounts Payable Aging Formula

Thanks:  0
Likes:  0

# Thread: Accounts Payable Aging Formula

1. ## Accounts Payable Aging Formula

I have a formula that calculates the # of days (aging) of an invoice.

Let's day in Col A1,this age is 28.In Col B1 is the invoice amt,\$100.

If the age in A is <30,I want to show the \$100 in col C

If The age in A is>30 but <60,I want to show \$100 in col D

If the age in A is>60,I want to show the \$100 in col E.

How and what is the best way to do this?

Thanks

\db

2. ## Re: Accounts Payable Aging Formula

In C:- =IF(A2<30,B2,"")

In D:- =IF(AND(A2>=30,A2<60),B2,"")

In E:- =IF(A2>=60,B2,"")

3. well i think you can do it this way:

in cell C1 enter this formula: =IF(A1<=30,B1,"")
in cell D1 enter this formula: =IF(AND(A1>=30,A1<=60),B1,"")
in cell E1 enter this formula: =IF(A1>60,B1,"")

Then select c1 to e1 and use the fill handle to fill the above formlas in the other cells below.

4. ## Re: Accounts Payable Aging Formula

oops someone types faster than i do

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•