Help

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

Multiple money formula

Topic Labels: Formulas
160 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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%.

1 Reply 1

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)