Re: Need help with formula for tiered pricing
Quick Base takes the first thing that is true from the formula and runs with it so you need to do it in a certain way as you suspected.
If(
<=250000,*0.05,
<=500000, *0.03,
>500000, *0.01)
So it hits the first line if the Transactions are less than or equal to 250,000. If the amount is higher then it goes to the second line which now means the amount is definitely above 250,001 so the formula checks to see if the amount is less than or equal to 500,000. If it is then it stops there and spits out *0.03, if not it continues to the next line as it knows the number is 500,001 or more.
In your formula I capped it to be more than 500k is 0.01 but you had it set to be more than 1 million, so it went from 500k or less to 1 million or more. Did you want another tier in between them?
If(
<=250000,*0.05,
<=500000, *0.03,
>500000, *0.01)
So it hits the first line if the Transactions are less than or equal to 250,000. If the amount is higher then it goes to the second line which now means the amount is definitely above 250,001 so the formula checks to see if the amount is less than or equal to 500,000. If it is then it stops there and spits out *0.03, if not it continues to the next line as it knows the number is 500,001 or more.
In your formula I capped it to be more than 500k is 0.01 but you had it set to be more than 1 million, so it went from 500k or less to 1 million or more. Did you want another tier in between them?
