please refer my attachment.
please suggest an excel formula in column AA,as i have type on this column.
required excel formula of ageing analysis
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
required excel formula of ageing analysis
You do not have the required permissions to view the files attached to this post.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- Administrator
- Posts: 78583
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: required excel formula of ageing analysis
See the attached version. I used VLOOKUP in combination with a lookup table.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 354
- Joined: 27 Oct 2013, 15:11
- Location: Gurgaon INDIA
Re: required excel formula of ageing analysis
Thanks Hans Sir.
It is working as desired.
It is working as desired.
Regards
Pradeep Kumar Gupta
INDIA
Pradeep Kumar Gupta
INDIA
-
- 3StarLounger
- Posts: 256
- Joined: 15 Aug 2016, 11:23
Re: required excel formula of ageing analysis
Or you can use this formula:
=LOOKUP(Z5,{0,46,91,181,366,1099},{"0-45","46-90","91-180","6 months to 1 year","more then 1 year","more then 3 years"})
=LOOKUP(Z5,{0,46,91,181,366,1099},{"0-45","46-90","91-180","6 months to 1 year","more then 1 year","more then 3 years"})