Calculated Column using IF Statement in SharePoint

%3CLINGO-SUB%20id%3D%22lingo-sub-275362%22%20slang%3D%22en-US%22%3ECalculated%20Column%20using%20IF%20Statement%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275362%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20two%20columns%20in%20my%20SharePoint%26nbsp%3Blist%20that%20will%20serve%20as%20the%20basis%20of%20the%20data%26nbsp%3Bthat%20will%20be%20needed%20on%20a%20third%20%22calculated%20column.%22%20My%20two%20columns%20are%20%5BContainer%20Content%5D%20and%20%5BContent%20Amount%5D.%20I%20have%20three%20different%20types%20of%20%5BContainer%20Content%5D%2C%20they%20are%20cases%2C%20pallet%2C%20slip%20sheet.%20The%20%5BContent%20Amount%5D%20will%20be%20a%20variable%20number%2C%20the%20user%20inputting%20the%20form%20will%20have%20this%20number%20entered%20when%20entering%20the%20record%20in%20SharePoint.%20On%20my%20third%20calculated%20column%2C%20I%20want%20to%20do%20the%20following.%20If%20the%20choice%20in%20%5BContainer%20Content%5D%20is%20pallets%20then%20divide%20%5BContent%20Amount%5D%20by%2036%2C%20if%20the%20choice%20is%20pallets%20then%20divide%20%5BContent%20Amount%5D%26nbsp%3B%20by%2032%2C%20if%20the%20choice%20is%20slip%20sheet%20then%20divide%20%5BContent%20Amount%5D%20by%2010.%20I've%20tried%20the%20following%20formula%20but%20I%20can't%20seem%20to%20get%20it%20to%20work.%20Can%20someone%20tell%20me%20where%20I%20have%20it%20wrong%3F%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3DIF(%5BContainer%20Content%5D%3D%22Cases%22%2C%5BContent%20Amount%5D%2F36%2C%3CBR%20%2F%3E%26nbsp%3B(IF%5BContainer%20Content%5D%3D%22Pallet%22%2C%5BContent%20Amount%5D%2F32%2C%3C%2FP%3E%3CP%3E(IF%5BContainer%20Content%5D%3D'Slip%20Sheet'%2C%20%5BContent%20Amount%5D%2F10)))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-275362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi,

I have two columns in my SharePoint list that will serve as the basis of the data that will be needed on a third "calculated column." My two columns are [Container Content] and [Content Amount]. I have three different types of [Container Content], they are cases, pallet, slip sheet. The [Content Amount] will be a variable number, the user inputting the form will have this number entered when entering the record in SharePoint. On my third calculated column, I want to do the following. If the choice in [Container Content] is pallets then divide [Content Amount] by 36, if the choice is pallets then divide [Content Amount]  by 32, if the choice is slip sheet then divide [Content Amount] by 10. I've tried the following formula but I can't seem to get it to work. Can someone tell me where I have it wrong?       

 =IF([Container Content]="Cases",[Content Amount]/36,
 (IF[Container Content]="Pallet",[Content Amount]/32,

(IF[Container Content]='Slip Sheet', [Content Amount]/10)))

0 Replies