In the "Frequency" column, I have data like this
frequency Calculation
0.02% rare
1% common
4% common
I want to print the word in below format in column "calculation' in below if-else conditon. How to do. Plz help.
very common 10%,
common 1% to < 10%;
uncommon 0.1% to < 1%;
rare 0.01% to < 0.1%;
very rare < 0.01%.