This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help

Multiple money formula

Topic Labels: Formulas
219 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Freda_Waller
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

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

0 Kudos
Reply
1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus
See Solution in Thread

‎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)
0 Kudos
Reply
Copyright © 2023 Khoros, LLC