Convert Excel formula to Sharepoint list

Question

Need help with conversion of an excel formula into a sharepoint list.

For context, the original mathematical formula is as follows:

√(6-a)2+(6-b)2 where a=attractiveness and b=achievability.

In Excel, the formula is:

=IF($C3>=0,ROUND(SQRT(((6-$C3)(6-$C3))+((6-$D3)(6-$D3))),2),"N/A")

Screenshot of formula attached.

I have columns on my list for Attractiveness and Achievability, but am stuck in figuring out the formula to use in the calculation column.

Answer 1

Hi @Raychel Plath ,

Thank you for posting in this community.

Use the following formula to create a calculated column (The data type returned from this formula is Number):

=IF(Attractiveness>=0,ROUND(SQRT((((6-Attractiveness)*(6-Attractiveness))+((6-Achievability)*(6-Achievability)))),2),"N/A")

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.