Skip to main content
Hi there, I keep getting the above message when entering the following formula. Any idea what I'm doing wrong? Thanks!

 

IF ( ISPICKVAL( Signatory_category__c , "Service Provider"), 

 

IF ( Staff_size_PSP__c > 200,  "£7720 Staff greater than 200", 

 

IF (Staff_size_PSP__c > 50, "£5850 Staff 51 to 200", 

 

IF (Staff_size_PSP__c > 25,  "£2700 Staff 26 to 50", 

 

IF (Staff_size_PSP__c > 10, "£780 11 to 25", "£430 Staff less than 10")))), 

 

IF ( ISPICKVAL( Signatory_category__c , "Investment Manager"), 

 

IF ( AUM__c > 50.00,  "£12500 IM AUM greater than 50", 

 

IF ( AUM__c > 29.99, "£11000 IM AUM 30 to 50", 

 

IF ( AUM__c > 9.99,  "£10000 IM AUM 10 to 29.99", 

 

IF (AUM__c > 4.99,  "£7000 IM AUM 5 to 9.99", 

 

IF (AUM__c > 0.99,  "£4000 IM AUM 1 to 4.99", 

 

IF (AUM__c > 0.099,  "£1500 IM AUM 0.1 to 0.99", "£1000 IM AUM 0 to 0.1")))))), 

 

IF ( ISPICKVAL(Signatory_category__c , "Asset Owner"), 

 

IF ( AUM__c > 9.99, "£7720 AO AUM greater than 10", 

 

IF (AUM__c > 4.99,  "£5850 AO AUM 5 to 9.99", 

 

IF (AUM__c > 0.99,  "£2700 AO AUM 1 to 4.99", 

 

IF (AUM__c > 0.099, "£780 AO AUM 0.1 to 0.99", "£430 AO AUM 0 to 0.1")))))))
2 个回答
  1. 2015年3月2日 14:58

    I would insist you try using a CASE like this:

    CASE(

    Signatory_category__c,

    "Service Provider",

    IF(

    Staff_size_PSP__c > 200,

    "£7720 Staff greater than 200",

    IF(

    Staff_size_PSP__c > 50,

    "£5850 Staff 51 to 200",

    IF(

    Staff_size_PSP__c > 25,

    "£2700 Staff 26 to 50",

    IF(

    Staff_size_PSP__c > 10,

    "£780 11 to 25",

    "£430 Staff less than 10"

    )

    )

    )

    ),

    "Investment Manager",

    IF(

    AUM__c > 50.00,

    "£12500 IM AUM greater than 50",

    IF(

    AUM__c > 29.99,

    "£11000 IM AUM 30 to 50",

    IF(

    AUM__c > 9.99,

    "£10000 IM AUM 10 to 29.99",

    IF(

    AUM__c > 4.99,

    "£7000 IM AUM 5 to 9.99",

    IF(

    AUM__c > 0.99,

    "£4000 IM AUM 1 to 4.99",

    IF (

    AUM__c > 0.099,

    "£1500 IM AUM 0.1 to 0.99",

    "£1000 IM AUM 0 to 0.1"

    )

    )

    )

    )

    )

    ),

    "Asset Owner",

    IF(

    AUM__c > 9.99,

    "£7720 AO AUM greater than 10",

    IF(

    AUM__c > 4.99,

    "£5850 AO AUM 5 to 9.99",

    IF(

    AUM__c > 0.99,

    "£2700 AO AUM 1 to 4.99",

    IF(

    AUM__c > 0.099,

    "£780 AO AUM 0.1 to 0.99",

    "£430 AO AUM 0 to 0.1"

    )

    )

    )

    ),

    NULL

    )

0/9000