Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
May 04, 2021 11:11 AM
Can I write a formula to do multiple things? For example I want to write a formula that when an items sales it calculates how much the fee would be based on the price.
So if I sold something and it was $15 or less the fee would be $2.95 but if something sold and it was more than $15 it would be 20%.
May 04, 2021 03:07 PM
Much like in Excel or Sheets you can string several functions together in a single Formula. Your formula actually only needs one function to work:
IF({Sale Price} > 15, {Sale Price} * 0.2, 2.95)