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 wa...
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")
