I am complete novice when it comes to these things, I have a set of
data, I want to band the data to display percentages besides it. So
when the data in column A is between 0-20 its 0% in B, 21-40 its 1%,
41-60 its 2%, 61-80 its 3% and 81-100 its 4%

A B
55 2%
66 3%
33 1%
23 1%
1 0%

I want the B column to work itself out, I have tried if else
statements without much look and a lot of error messeages, can anyone
help please?