Skip to main content

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

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!

Reply


Terms & Conditions