Calculate Based on Field Entry

Calculate Based on Field Entry

Hi,

      I have a formula I am working on to calculate a weight/score for a particular entry.  Basically the part that is giving me trouble is that if there is an entry in the "Program_Manager_2 field, i need it to divide the weight/score by 2 and then multiply by .8, if there is NO entry in Program_Manager_2 then I just need it to multiply by .8...  This is the formula i have been working on (I have highlighted the parts that I think are wrong):

if((Program_Manager_2  !=  ""),(Staff_Requirement  /  2  +  if((Living_Situation  ==  "Community"),1,0)  +  if((Intensive_Family_Involvement  ==  "Yes"),2,0)  +  if((Split_Shifts  ==  "Yes"),2,0)  +  if((Payee  ==  "Yes"),1,0)  +  if((BSP  ==  "Yes"),1,0)  +  if((Monthly_Medical  ==  "2 or Less"),1,0)  +  if((Monthly_Medical  ==  "3 to 4"),2,0)  +  if((Monthly_Medical  ==  "5 or More"),3,0)  +  if((Delegated_Nursing  =  "Yes"),1,0)  /  2  *  0.8),(Staff_Requirement  /  2  +  if((Living_Situation  ==  "Community"),1,0)  +  if((Intensive_Family_Involvement  ==  "Yes"),2,0)  +  if((Split_Shifts  ==  "Yes"),2,0)  +  if((Payee  ==  "Yes"),1,0)  +  if((BSP  ==  "Yes"),1,0)  +  if((Monthly_Medical  ==  "2 or Less"),1,0)  +  if((Monthly_Medical  ==  "3 to 4"),2,0)  +  if((Monthly_Medical  ==  "5 or More"),3,0)  +  if((Delegated_Nursing  =  "Yes"),1,0)  *  0.8))

     Any help would be appreciated.

Thanks

Nick