I need to create a nested formula. I currently have a formula that reads: IF(AND(Average_Annual_Sales__c > 10000, Average_Annual_Sales__c < 50000), "1", ""). I need to add another IF statement that says IF Average Annual Sales is > than 50000 and < 100000 that the field should populate as "2", then another statement for >100000 and < 1000000 to populate as 3 and so on. I tried just entering a comma at the end of the first line and using the same formula (with changes of course) but I get an error.
Here's an example of how you can extend your existing formula to include additional conditions
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 < 1000000
),
"3",
// Add more conditions as needed
""
)
)
)
- The outer IF checks the first condition: if Average_Annual_Sales__c is between 10000 and 50000, it returns "1".
- If the first condition is not met, the second IF is checked: if Average_Annual_Sales__c is between 50000 and 100000, it returns "2".
- If the second condition is not met, the third IF is checked: if Average_Annual_Sales__c is between 100000 and 1000000, it returns "3".
- You can continue this pattern to add more conditions as needed.
