Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Calculated Net with or without commission

Topic Labels: Formulas
222 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I can’t quite seem to get this right.

Fields at play:

  1. Asking Price - this is how much a seller wants for their equipment
  2. Commission Included? - this is a yes or no single select field
  3. % Commission - this we type in as each sale is different, usually 10%
  4. Commission - this is #1 * #3.
  5. Net to Seller - this is the formula that is tripping me up.
    So, what I want this to be is if the Commission Included field is “Yes”, then calculate Asking Price minus Commission. But if Commission Included field is “No”, then Net to Seller would just equal the Asking Price.

Here’s what I wrote that doesn’t work:
IF {Comm Included?}= Yes, {Asking Price} - Commission, {Asking Price}

What am I missing? Help appreciated!!!

0 Replies 0