I would like to use an IF function to obtain an answer to "Approve" or "Decline" within a SharePoint list. My formula works in Excel but not in SharePoint.
I have 4 SharePoint columns:
column name = [Request Type], excel cell =G2 (to be "approved" the word "TD" must be chosen)
column name = [Position title], excel cell =F2 (to be "approved" the word "MEM" must be chosen)
column name = [% Discount], excel cell =J2 (to be "approved" value must be <=0.6)
column name = [Criteria Total], excel cell =S2 (to be "approved" value must be >=100)
My formula works in Excel but not in SharePoint.
Excel formula is: =IF(AND(G2="TD",F2="MEM",S2>=100,J2<0.7),"APPROVE","DECLINE")
When I enter it in SharePoint I change the cells to the column name and it always says "decline" when the answer should be "approve"
Can someone please help me?
[% Discount]
and[Criteria Total]
columns in SharePoint list?