Formula for depending quantity

Platform discussions Special workflows & use cases
1

I want to perform a formula in a column, but I don’t know if it’s possible.

The problem is:

I have a base cost, for example $10, if I sell more than 1000 pieces, I have to rest $1.50 to that cost, if I sell more than 3000 pieces, I have to rest $1.75 to the base cost.

Is there a way that a column of formula can perform the rest depending on what I type on a number column (quantity)?

2

Hey Luis, do you need the formula to output $1.50 for example? Or should it also consider the $10 base cost you mentioned? If the $10 should be included in the formula, could you please confirm if you’re trying to subtract $1.50 and $1.75, or if there’s something else you’re trying to do?

3

Yes!

I’m trying to substract 1.50, 1.75, and 2.00, depending on the quantity that the client requires. For example, if the client wants 1-999 , is the same cost ($10), if they want 1000-2999, the cost is ($10-$1.50), if they want more 3000-4999, the cost is ($10-$1.75);

I want a formula that depending on the column of quantity (number) or it could be a column of status that has the quantity, perform on a column.

4

Hi, Just a quick thought to using nestef IF formulas.
Here is the board setup:

image
image825×211 13.4 KB

Order Size is a number column showing the units you order
Price is Price
Here is the formula:
IF(AND({Order Size} >= 1, {Order Size} <= 999), {Price} * {Order Size}, IF(AND({Order Size} >= 1000, {Order Size} <= 2999), ({Price} - 1.50) * {Order Size}, IF(AND({Order Size} >= 3000, {Order Size} <= 4999), ({Price} - 1.75) * {Order Size}, 0)))
There are other ways to do this, to be sure, this just seemed most direct.
Cheers!
Ian