|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
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! |
#13
|
|||
|
|||
Quote:
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|