Help

Multiple money formula

Topic Labels: Formulas
357 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Freda_Waller
4 - Data Explorer
4 - Data Explorer

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)