Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Multiple money formula

Topic Labels: Formulas
701 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
Kamille_Parks
16 - Uranus
16 - Uranus

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)