aging report

  • Thread starter Thread starter D
  • Start date Start date
D

D

I have a cell with a number in it and i want to put that number in another
column based on number in that column.

days 1-10 days 11-20 days 21-30 days > 30 days
a1: 10

I want the number to show up in the corresponding column and put a zero in
the other columns.
I have a formula for the 1-10 days and the >30 days, but i need some help
with a formula for the 11-20 and 21-30 days.


thanks
 
For the 11-20 days column, you could use a formula like:

=IF(AND($A2>=11,$A2<=20),$A2,0)

Then, copy the formula to the 21-30 days column, and adjust the 11 and 20.
 
I'm sure this will be the answer i have been looking for or at least a place
for em to start. Thanks Debra, your great.
 
You're welcome! I'm sure you'll figure out the rest, but if not, post
another question, and someone should be able to help.
 
Back
Top