Hello,
I am trying to write a nested IF formula to produce values in the farthest right column of my spreadsheet ([Final Tally CommissionAmount]) based on criteria I will list below.
Here are my columns:
PlanOpenDate,
TranAmount,
PMC_Key,
CommissionAmount,
CategoryParameter_ID,
[Final Tally CommissionAmount]
All columns have values except for [Final Tally CommissionAmount]. This last column will hold my formula.
CRITERIA
For each row in my table, I want to store in the [Final Tally CommissionAmount] column a value based on the following:
If CategoryParameter_ID = 2 then [Final Tally CommissionAmount] = TranAmount * 0.005
If CategoryParameter_ID = 1 then check PlanOpenDate. If PlanOpenDate is greater than 2/28/2006 then [Final Tally CommissionAmount] = TranAmount * 0.01. If PlanOpenDate is less than or equal to 2/28/2006 then [Final Tally CommissionAmount] = TranAmount * 0.015
Also if PMC_key is 1, 70 or between 700-799 inclusive, [Final Tally CommissionAmount] = 0
If none of these criteria exist then [Final Tally CommissionAmount] = TranAmount
Any help would be appreciated.
Thanks,
basscomp
I am trying to write a nested IF formula to produce values in the farthest right column of my spreadsheet ([Final Tally CommissionAmount]) based on criteria I will list below.
Here are my columns:
PlanOpenDate,
TranAmount,
PMC_Key,
CommissionAmount,
CategoryParameter_ID,
[Final Tally CommissionAmount]
All columns have values except for [Final Tally CommissionAmount]. This last column will hold my formula.
CRITERIA
For each row in my table, I want to store in the [Final Tally CommissionAmount] column a value based on the following:
If CategoryParameter_ID = 2 then [Final Tally CommissionAmount] = TranAmount * 0.005
If CategoryParameter_ID = 1 then check PlanOpenDate. If PlanOpenDate is greater than 2/28/2006 then [Final Tally CommissionAmount] = TranAmount * 0.01. If PlanOpenDate is less than or equal to 2/28/2006 then [Final Tally CommissionAmount] = TranAmount * 0.015
Also if PMC_key is 1, 70 or between 700-799 inclusive, [Final Tally CommissionAmount] = 0
If none of these criteria exist then [Final Tally CommissionAmount] = TranAmount
Any help would be appreciated.
Thanks,
basscomp