Hi, I have this Nested If statement that I can’t get it to work in SharePoint Calculated Field, Please help.
I’m trying to get the result, If [Inventory_Reach incl_Supply] greater than 3 OR [Inv_CarryingCost] greater than [Cancellattion_Fee] and [Cancellation_Fee] is not blank field. give me “Review”, else leave it blank.
=IF(OR[Inventory_Reach incl_Supply]> 3, AND [Inv_CarryingCost]>[Cancellation_Fee],LEN[Cancellation_Fee])>0)),”REVIEW”,””)
(Visited 20 times, 1 visits today)
