In C:- =IF(A2<30,B2,"")
In D:- =IF(AND(A2>=30,A2<60),B2,"")
In E:- =IF(A2>=60,B2,"")
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 ...
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
In C:- =IF(A2<30,B2,"")
In D:- =IF(AND(A2>=30,A2<60),B2,"")
In E:- =IF(A2>=60,B2,"")
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.
oops someone types faster than i do
Like this thread? Share it with others