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