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

Need Help Making IF THEN formula for commissions

246 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi Community,
I need help making an IF THEN formula. I don’t know how to do this and would love your assistance.

I have records with the following relevant columns:

  • Price of Home (rental prices i.e. $1,000 or sale prices i.e. $500,000)
  • % Commission (7.5% or 8.333% or 2.5% or 3%)
  • GCI ($ gross commission income)

I want to make the following formula to fill in the GCI column:
IF % Commission is 2.5% OR 3% THEN GCI is calculated by {Price of Home}x{%Commission}
IF % Commission is 7.5% OR 8.333% THEN GCI is calculated by {12}x{Price of Home}x{%Commission}

Thanks so much!!!

1 Reply 1

Hopefully I captured what you needed here:

IF(
    OR(
        {% Commission} = .025,
        {% Commission} = .03
    ),
    {Price of Home} * {% Commission},
    IF(
        OR(
            {% Commission} = .075,
            {% Commission} = .083333
        ),
        12 * {Price of Home} * {% Commission}
    )
)

Best of luck!