Price items to scale to create invoices


#1

Hey,

Let me know if there is another question I can reference for answers to mine.

I am trying to set up a table that reflects changes in price based on how many you buy.

EX. 1 color Business Cards are .65 for 1-25, .60 for 25-50, ect, ect. There is also 4 color business cards for a completely different set of prices.

Any suggestions or past questions I can check out as a guide?


#2

Off the top of my head I can’t point you towards an example, but you may want to look through the applicable Airtable templates or browse Airtable Universe. If you have a large number of products, offer varying pricing programs, or frequently change prices, you’ll want to find a solution that works from a separately maintained price list table to keep from having to modify formulas frequently.

If your product offering is relatively simple and static, what you’re looking for is an IF() statement of some degree of complexity. Something along the lines of the following should get you started:

IF(
    Number,
    IF(
    UPPER(
        {BC Type}
        )='1C',
        IF(
            Number<=25,
            Number*0.65,
            IF(
                Number<=50,
                Number*0.6,
                IF(
                    Number<=75,
                    [etc.]
                    )
                )
            ),
        IF(
            UPPER(
                {BC Type}
                )='4C',
            IF(
                Number<=25,
                Number*0.??,
                IF(
                    Number<=50,
                    Number*0.??,
                    IF(
                        Number<=75,
                        [etc.]
                        )
                    )
                )
            )
        )
    )