 ShowAll Questionssorted byDate Posted Chris McKaughan

# Help with ISPICKVAL IF AND FORMULA

Hello,

I'm an noob and I'm trying to write a formula that compares a picklist value and a formula result and will enter a number (I need to do math in future formulas so can't use text). This is what I have:

IF(AND(ISPICKVAL( Size__c , "S"), Tier__c= "Tier 1"), 675,
IF(AND(ISPICKVAL( Size__c , "S"), Tier__c= "Tier 2"), 695,
IF(AND(ISPICKVAL( Size__c , "S"), Tier__c= "Tier 3"), 725,
Tier__c)))

Getting the following error:

Incorrect parameter type for function 'IF()'. Expected Number, received Text (Related field: Formula)

If I change the field type to Text and add quotes around the numbers it works but I really need it to be a number.

Any help would be greatly appreciated!!!!

Any help would be appreciated. Best Answer chosen by Chris McKaughan Pankaj_Ganwani
If you really need it to be number then you can use either 0 or -1 instead of using Tier__c in else part. Pankaj_Ganwani
IF(AND(ISPICKVAL( Size__c , "S"), Tier__c= "Tier 1"), 675,
IF(AND(ISPICKVAL( Size__c , "S"), Tier__c= "Tier 2"), 695,
IF(AND(ISPICKVAL( Size__c , "S"), Tier__c= "Tier 3"), 725,
Tier__c)))

The bold one in the above formula should be of type Number since your formula return type is Number. Chris McKaughan
Thanks for the reply. What if I just want to populate this field I'm creating with the number value? Pankaj_Ganwani
If you really need it to be number then you can use either 0 or -1 instead of using Tier__c in else part.
This was selected as the best answer Chris McKaughan
Perfect. THANK YOU!!!