You need to sign in to do that
Don't have an account?
BCPE
Formula help for calc based on a picklist value
I have an easy one here, I think -- but my track record working with picklists in formulas is not so good.
I'm creating a custom field for Quotes to calculate sales tax.
I have a picklist field Sales Tax with two values: CA and Out-of-State. Tax is 9.75% and 0%, respectively.
I'm trying to reference that picklist val to calc tax on a qoute's Total Price.
ISPICKVAL(Sales_Tax__c, "CA", (TotalPrice * 0.0975), 0)
The error I get is:
Incorrect number of parameters for ISPICKVAL(), expected 2 received 4.
I'd appreciate any help!
You're almost there. Just need to nest ISPICKVAL within an IF statement. Try this:
IF( ISPICKVAL(Sales_Tax__c, "CA") , (TotalPrice * 0.0975), 0)
All Answers
You're almost there. Just need to nest ISPICKVAL within an IF statement. Try this:
IF( ISPICKVAL(Sales_Tax__c, "CA") , (TotalPrice * 0.0975), 0)
Of course, thank you! Quick side question...
If I had, say, 4 picklist vals instead of 2 -- how would I best set that up? Would I use an "AND" before the "IF"?
Appreciate your help!
BE
Assuming the other states have different sales tax %, then you could have something like this...
IF( ISPICKVAL(Sales_Tax__c, "CA") , (TotalPrice * 0.0975),
IF( ISPICKVAL(Sales_Tax__c, "XX") , (TotalPrice * X.XXXX),
IF( ISPICKVAL(Sales_Tax__c, "XX") , (TotalPrice * X.XXXX), 0)))
Thanks a million!
BE