Results 1 to 4 of 4

Accounts Payable Aging Formula

This is a discussion on Accounts Payable Aging Formula within the Excel Questions forums, part of the Question Forums category; I have a formula that calculates the # of days (aging) of an invoice. Let's day in Col A1,this age ...

  1. #1
    New Member
    Join Date
    Jul 2004
    Posts
    7

    Default 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. #2
    Board Regular Todd Bardoni's Avatar
    Join Date
    Aug 2002
    Location
    Rochester, MI USA
    Posts
    3,044

    Default 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. #3
    Board Regular
    Join Date
    Sep 2002
    Location
    Iran
    Posts
    79

    Default

    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. #4
    Board Regular
    Join Date
    Sep 2002
    Location
    Iran
    Posts
    79

    Default Re: Accounts Payable Aging Formula

    oops someone types faster than i do

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com