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
Did you mean:
5 - Automation Enthusiast

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!!!

7 - App Architect

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!