Formular to Extract Numbers out of a string

[Christian_Wilhe]

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 ?

[Kamille_Parks]

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"