Forum Discussion

GregoryRand's avatar
GregoryRand
Qrew Member
4 years ago

IF formula that applies another formula

I am using a field to calculate a home price with a  commission rate. However, If the "market" field is "Atlanta", I need to subtract 70% from the result. All other markets I don't subtract. Help?

Here is the base formula. How to I subtract 70% from the result if it's in Atlanta?

[Purchase Price]*[Commision %]

------------------------------
Gregory Rand
------------------------------
Formulas and functions
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    4 years ago
    I suggest you also add your commission adjustment to that table and make it a look up field in the table where you calculate the Home Price

    1 Los Angeles  100%
    2 Chicago   100%
    3 New York  100%
    4 Atlanta   30%
    5 Dallas    100%

    and so on



    You can then do this

    [Purchase Price]*[Commission %]*[Market Adjustment]

    Then you can keep the same formula for all markets.  If you add another City and it is 85% reduction, you put 15% in the Market table and nothing else has to change.  Just keep that table up to date instead of changing formulas.




    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------