put this in column D1 and copy it dowm
You want need column E delete it

=ROUNDUP(100/B1,0)
This will divide your rating into 100 and then round it up to the next hole number.

Cheers

Hi Crackone,

That's exactly what I was after!
Thanks for your patience and help - much appreciated. That's what I like about this website the help that is freely available from all sources - Sensational!

I am a self accredited "gun" at excel so if you want to send me a sample i can see if i can automate more for you.

you know Christmas holidays and the like - a bit bored - so need some new projects.

cheers

Aussie