aging report

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
 
D

Debra Dalgleish

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

D

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

Debra Dalgleish

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