Help : Formula for different condition

As variant that could be done with Power Query

- first create a table for the conversion of points with 1000pt gradation and till possibly max amount of points (let say 50000pts). It could be generated by formulas, but that's 5 minutes job to generate such table manually, it's static and never be recalculated;

- query that table as connection;

- query all members with points, group by members to sum points for every of them and lookup conversion table from firts query. How to lookup is in details here https://www.powerquery.training/portfolio/vlookup-true-in-power-query/

- we don't need the list of members with conversion, just sum and return total company liability as one number

And in attached.