I have a column in my SharePoint list named "Container Content." When adding a record in SharePoint you can choose one of three items in this column, it is a choice column. The three items you are able to choose are "Cases, Pallets, SlipSheet."I also have a column named "Content Amount." This column will tell us the amount of what the container content is. For example, if the container content is "cases" and the container amount is 980, then I have 980 cases. I have created a new calculated column that will need to take the value of the "container content" column and divide by 36 if it's Cases, divide by 32 of its pallets and divide by 10 if it's slip sheets. I have tried to create the formula but it is not working. I am a noob when it comes to formulas. I am hoping someone can help and/or stear me in the right direction.
Here is my code sample.
=IF([Container Content]="Cases"/36)+IF([Container Content]="Pallets"/32)+IF([Container Content]="Slip Sheets"/10)