Sumproduct Tier Pricing

Hello, it is possible to use the Sumproduct formula for Tier Pricing in Airtable? I am trying to calculate the revenue for a marketing agency and it´s based on tiers depending on the total amount of media spend, in Excel it looks like this, example: =(SUMPRODUCT(–(sum($D205)>={0,99999,200000,9999999}),sum($D205)-{{0,99999,200000,9999999}},{0.2,-0.025,-0.025,-0}))

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.