+ Start a Discussion
Emily ChanEmily Chan 

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! 
Ketankumar PatelKetankumar Patel
Hi Emily Chan, 

Try this. let me know if you get any errors...
IF(
(
     Case( Seniority__c ,
	      "VP",3,
		  "Director",2,
		  0) 
		  +
     Case( Infer_Rating2__c ,
	      "A",1,
		  "B",0.5,
		  "D",-1,
		  0)
		  +
     IF(ISBLANK(Account.infer_smart_signal_company_size__c),
	 Case(
	       Account.#_of_employees,
		   "50-100", 0.5,
		   1
		  ),
	 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)
		   +
	 IF(ISBLANK(Account.infer_smart_signal_company_size__c),
	  Case(
	       Account.#_of_employees,
		   "50-100", 0.5,
		   1
		  ),
     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)