Allocate points from 0-100 based on value

Hi

I have a count on the number of supplier items. I have to give the supplier points from 0-100, where a low number of items means higher points and a high number of items means a low score. The min. value of items is 1 and the max. value is 3.000.

e.g.

Supplier A: 1 items (100 points)
Supplier B: 3.000 items (0 points)
Supplier C: 5.000 items (0 points).

Maybe someone can help me.

Best regards
Morten

Re: Allocate points from 0-100 based on value

Thank you for your answer.
It's not working exactly like was my intention, but maybe I was not clear enough For example if we have a Supplier D with e.g. 750 items, then this supplier should get a score between 0-100 proportionally.

Best regards
Morten