I dived into a nested if statement and it's now way over my head. Could you please take a look and let me know why it doesn't work?
All I wantis to categorize our accounts based on multiple criteria. Region, Sector and later on the number of employees. But i've been at it for 2 hours to no avail...
IF(
ISPICKVAL( Sector__c, "Supplier/Distributor"), "Supplier",
IF(
ISPICKVAL( Account_Region__c , "Middle East"), "Middle East",
IF(
ISPICKVAL( Account_Region__c , "Americas"),
IF(BEGINS(TEXT(Sector__c) , "Restaurants")), "US Restaurants", "US Hotels")))
The error message reads:
Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 1
Many thanks in advance!
Csongor