multiple nesting IF formulas

[Freda_Waller]

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

[Kamille_Parks]

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)