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