How do I convert an Excel formula to Sharepoint Calculated Field?

Question

I have to calculate the following table to get the result %Efectividad:

I have the formula in Excel:

=SI(B2="",0,SI(1-((B2-A2)/30)>1,1,1-((B2-A2)/30)))

But you need it for a Sharepoint list.

It is the percentage difference between two dates for Sharepoint List.

Can you help me?

Answer 1

Hi @Frankelis De Jesús ,

Use this formula in the calculated column(%Efectividad):

=IF(Date_Completed="",0,IF(((Date_Completed-Due_Date)/30)>1,1,(1-((Date_Completed-Due_Date)/30))))

The display effect is shown in the following figure:

---

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.