Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Sumproduct Tier Pricing

141 0
Showing results for 
Search instead for 
Did you mean: 

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}))

0 Replies 0