Ageing Bucket using IF staement

[tamil9288]

Hi ,

i have variance % in column A which includes positive and negative %, i have put ageing bucket using this formula
=IF(A2<5%,"0% to 5%",IF(A2<10%,"5% to 10%",IF(A2<15%,"10% to 15%",IF(A2<20%,"15% to 20%",IF(A2>20%,">20%")))))

but now i want to add agieing bucket for negative value as well

Ggeing bucket which is checking for postive value should check for negative value as well . Below is expamle.

Anything <5% and <-5% should fall under 0 to 5%.

[TABLE="width: 176"]
<colgroup><col width="88" span="2" style="width:66pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 88"]0.00%[/TD]
[TD="class: xl63, width: 88"]0% to 5%[/TD]
[/TR]
[TR]
[TD="class: xl63"]-2.18%[/TD]
[TD="class: xl63"]0% to 5%[/TD]
[/TR]
[TR]
[TD="class: xl63"]1.28%

[/TD]
[TD="class: xl63"]0% to 5%[/TD]
[/TR]
</tbody>[/TABLE]

Please assit.

 

[Peter_SSs]

Welcome to the MrExcel board!

See if this, copied down, does what you want. If not please give more examples and the expected results.

Excel Workbook
	A	B
2	-6%	5% to 10%
3	2.30%	0% to 5%
4	-0.40%	0% to 5%
5	17%	15% to 20%
6	-25%	> 20%
7	-12%	10% to 15%
Ageing

 

[tamil9288]

Thank you so much for your assistance. This formula helped.

 

[Peter_SSs]

Thank you so much for your assistance. This formula helped.

Good news. Thanks for letting us know.