
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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%.
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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)
