Hi, 

So I have a SharePoint list which has:

A product column with lets say 5 different products, so 5 different rows.

Then two columns which are for August and July (I have all the months but trying to keep it simple) and these have manually input numbers in.

And then I have a calculated column

I want the calculated column to do the calculation ([AUG-JUL])/30. However I only want it to do this calculation for products 1-3, For products 4-5 I want it to do the calculation ([AUG-JUL])/45. Is this even possible to do in a sharepoint list? I’ve been trying to play around with it but keep getting syntax error.

Any input is much appreciated.

Thanks

​Hi, So I have a SharePoint list which has:A product column with lets say 5 different products, so 5 different rows.Then two columns which are for August and July (I have all the months but trying to keep it simple) and these have manually input numbers in.And then I have a calculated columnI want the calculated column to do the calculation ([AUG-JUL])/30. However I only want it to do this calculation for products 1-3, For products 4-5 I want it to do the calculation ([AUG-JUL])/45. Is this even possible to do in a sharepoint list? I’ve been trying to play around with it but keep getting syntax error.Any input is much appreciated.Thanks  Read More

​