Help with doing a custom calculation

Hello @willward1

Your project is very simple to implement with our plugin, using conditional statements in the equation associated to the calculated field:

(function(){
if(fieldname2 <= 50) return 2;
if(fieldname2 <= 200) return 2+CEIL((fieldname2-50)/25);
if(fieldname2 <= 500) return 2+CEIL((fieldname2-50)/25);
if(fieldname2 <= 1000) return 20+CEIL((fieldname2-500)/33);
if(fieldname2 <= 2000) return 25+CEIL((fieldname2-1000)/50);
return 55+CEIL((fieldname2-2000)/100);
})()

The support service does not cover the implementation of the users’ projects (forms or formulas). If you need additional help implementing your project, you can contact me through my private website: Customization

Best regards.