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%.
<colgroup><col width="88" span="2" style="width:66pt"> </colgroup><tbody>
</tbody>
Please assit.
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%.
0.00% | 0% to 5% |
-2.18% | 0% to 5% |
1.28% | 0% to 5% |
<colgroup><col width="88" span="2" style="width:66pt"> </colgroup><tbody>
</tbody>
Please assit.