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
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