I created a new field called Financial Score. I want to use data entered in a field called Average Annual Sales and IF the data is greater than 10000 AND less than 50000 I want the number "1" to show up in the Financial Score field. Here is the formula I tried but I get an error: IF(AND(Average_Annual_Sales__c > 10000, Average_Annual_Sales__c < 50000),"1"). The Error message is: Incorrect number of parameters for function 'IF()'. Expected 3, received 2.
Hello@Marla Elliott,
try to use multiple IF statements
Syntax
IF(isTrue,
then-thing,
IF(otherTrue,
other-thing,
other-then-thing
)
)
try like
IF(
AND(Average_Annual_Sales__c > 10000,Average_Annual_Sales__c <= 50000 ),1 ,
IF(
AND(Average_Annual_Sales__c > 50000,Average_Annual_Sales__c <= 100000 ),2,
IF(
AND(Average_Annual_Sales__c > 100000,Average_Annual_Sales__c <= 150000 ),3,
IF(
//next conditions...
........,
---,
null)
)
)
Please check
