Skip to main content
Question

IF formula that applies another formula

  • April 11, 2021
  • 0 replies
  • 46 views
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Quickbase Alumni
  • April 11, 2021
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
------------------------------
Terms & ConditionsAccessibility statement