# Formular to make discount

Hi All . i have i hope a simple question
I have a single select where my employees can choose a size of a product .
in the next field i have a price field and the next is a amount field and the last is a formular to get the price

this works as it should .

my question now , is there a way to give discount if we choose more than one in amount

for example i want to add a 50 % discount if anyone chooses 2 in amount . is this possible in Airtable ?

The formula would be something like:

``````{Price} *
IF(
{Amount},
SWITCH(
{Amount},
"1", 1,
"2", .5,
1,
),
1
)
``````

The above formula is multiplying the `{Price}` field by 1 if: the `{Amount}` field is empty, or if the `{Amount}` field is anything but `"2"`. If `{Amount}` is `"2"` it will multiply the `{Price}` by .5.

If you need to add more discounts (i.e. 75% off for 3), then add `"3", .75,` to the line below `“2”, .5"

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