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? ...
Forum Discussion
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
------------------------------
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
------------------------------