Formula for aging

**arnab0711** · 02-03-2010, 01:37 AM

Hi All,
Please provide the formula for below aging.
0 < 90 days
90 >90-180 Days
180 >180 Days
Column M has the aging details.
I am attaching the file below.
Thank you in advance for the help.

**Paul** · 02-03-2010, 01:55 AM

Arnab, what do you want to do with the values in column M? Or are you trying to update other cells based on the aging value in column M?

**arnab0711** · 02-03-2010, 02:05 AM

Hi Paul,
I want a ' if ' formula where if the aging is 0 to 90 days it will show 0 < 90 days,if the the aging is 91 to 180 days it will show 90-180 Days,and so on.

**yourskarthik** · 02-03-2010, 02:14 AM

Hello arnab0711,,

Try this =IF(M2<=90,"0<90",IF(M2<=180,"90<180",">180"))

**Paul** · 02-03-2010, 02:17 AM

The following code will replace the values in column M with their appropriate ranges:

Please Login or Register  to view this content.

If you don't want to use a macro, you can use a formula in an open column (like column R). In R2 put

=IF(M2>180,"> 180",IF(M2>=90,"90 - 180",IF(M2>=0,"< 90","")))

**arnab0711** · 02-03-2010, 02:28 AM

Thanks a lot for the reply,can we also have a macro for automatically creating a pivot out of it,where in the organisation name will be in the row section,the aging formula will be in the column section and sum of value in the data section.

**DonkeyOte** · 02-03-2010, 05:01 AM

Pivot Table thread created: http://www.excelforum.com/excel-work...utomation.html

arnab0711, please mark this particular thread SOLVED.

Originally Posted by E.F.Gubbins

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**JAPHO** · 02-11-2024, 06:37 AM

Calculate days outstanding using =DAYS(start date,End date) eg in CELL 1A to return value in B1

0-90 days use =IF(A1<=90,B1,0)
91-180days use =IF(AND(A1<=180,A1>=91),B1,0)
181-270days use =IF(AND(A1<=270,A1>=181),B1,0)
270-360 days use =IF(AND(A1<=360,A1>=271),B1,0)
>360 days use =IF(A1>=360,B1,0)

**Glenn Kennedy** · 02-11-2024, 06:59 AM

1. This thread is 15 years old.

2. Your answer looks like it was generated by AI, and does not answer the question, as asked.

3. Please read the yellow banner (top) about AI.

4. Thread closed.