Calculating columns based on multiple choice and multiplying with different values in Sharepoint

Question

Hi there,

I am still relatively new to Sharepoint Online and MS Lists and am currently in the process of developing a query schema that should also contain KPIs. I am currently struggling with the following example. There are three production sites that are set up as multiple choice:

• Germany (0,68%)
• USA (0,7244%)
• France (1,67%) The direct material costs are requested in another, separate column. Now I would like to allocate the selected location with the material costs via calculated columns in MS Lists, depending on the location, which have different percentages. My current approach is as follows: =IF([production location]="Germany"; [direct material costs]*1.0698; IF([production location]="USA"; [direct material costs]*1.0724; IF([production location]="France"; [direct material costs]*1.01167; [direct material costs]))) I would like to avoid power automate or power apps. Thanks for your help.

Answer 1

Hi @Christopher Lange,

Thank you for posting in this community.

The type of column I'm testing:

• production location: Choice column (Single choice)
• direct material costs: number column
• Result: Calculated column(The data type returned from this formula is Number)

Please try replacing the ; in your formula with，.

Formula:

=IF([production location]="Germany",[direct material costs]*1.0698,IF([production location]="USA",[direct material costs]*1.0724,IF([production location]="France",[direct material costs]*1.01167,[direct material costs])))

Here is my test result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.