Forum Discussion
If statement in SharePoint
Good Evening
I am trying to enter what I feel is a rather simple "IF" statement but I can't figure it out.
I have a Field titled "Item Type" and one titled "FLW - Business Days Remaining" and want to return a "2" if the Item Type equal "Prospect" and "FLW - Business Days Remaining" is grater than 2.
This is what I have
=IF(AND([Item Type]="Prospect",[FLW - Business Days Remaining] >2,"2")))
Any help would be greatly appreciated
JasonM123 can you move the closing parentheses of the and function directly after the second expression? https://support.microsoft.com/en-gb/office/and-function-78956048-53c7-484a-ab0b-6e70d7f03400
AND(logical1,logical2)Try something like
=IF(AND([Item Type]="Prospect",[FLW - Business Days Remaining]>2),"2","Not return 2")
JasonM123 can you move the closing parentheses of the and function directly after the second expression? https://support.microsoft.com/en-gb/office/and-function-78956048-53c7-484a-ab0b-6e70d7f03400
AND(logical1,logical2)Try something like
=IF(AND([Item Type]="Prospect",[FLW - Business Days Remaining]>2),"2","Not return 2")
