Sign Up ›
  • Emily Chan
  • NEWBIE
  • 0 Points
  • Member since 2015
  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 0
    Replies
1 replies

Need help with a formula

This is how we caluclate call points: IF(
(
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case(  Infer_Rating2__c ,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1)
)
>= 0,
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case( Infer_Rating2__c,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1),
0)

What I want to do is; if (Account.infer_smart_signal_company_size__c) is "" or null, then look here (#_of_employees, "50-100", 0.5). how do I do this? how would I add it on to the current statement?

​Many thanks! 
0 replies

Add a clause to an IF statement

This is how we caluclate call points: IF(
(
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case(  Infer_Rating2__c ,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1)
)
>= 0,
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case( Infer_Rating2__c,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1),
0)

What I want to do is; if (Account.infer_smart_signal_company_size__c) is "" or null, then look here (#_of_employees, "50-100", 0.5). how do I do this? how would I add it on to the current statement?

Many thanks! 
1 replies

Need help with a formula

This is how we caluclate call points: IF(
(
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case(  Infer_Rating2__c ,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1)
)
>= 0,
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case( Infer_Rating2__c,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1),
0)

What I want to do is; if (Account.infer_smart_signal_company_size__c) is "" or null, then look here (#_of_employees, "50-100", 0.5). how do I do this? how would I add it on to the current statement?

​Many thanks!