I am trying to create a calculated column based on this:
where, L6 is a yes/no column, C6 is a number column and the lookup basically calculates the percentage based on another column, let's say column B from SharePoint (choice, 1-6).
This way, the lookup basically multiplies in the initial IF C63/53*10% if [Column B] is 1, 20% if it's 2 and so on.
IF [Column B]=1,0.10,0 IF [Column B]=2,0.20,0 IF [Column B]=3,0.30,0
Both conditions must be true for this to happen, so if L6 is False, the answer should be 0. Otherwise, if the L6 column is true, it multiplies the values with the percentage, depending on the value selected from [Column B].
Please let me know how I can be more specific for you to be able to help me in this matter.
Many thanks in advance!