Hi All,
Hope you are doing well!...I am trying to build an if conditional statement with the following conditional to predict if an order would result in a claim...Can you please help me with that...Also I have added a sample workbook with expected result
1) If the number of customer communications >=5 then it would result in a claim
(OR)
2) if the number of customer communications between 1 to 4 (1<=4- both 1 and 4 included) and the order bucket between 8 to 10 it would result in a claim
My try:
IF(OR(noofcustomercommunications>=5,AND(noofcustomercommunications>=1,noofcustomercommunications<=4,orderbucket>=8,orderbucket<=10),1,0))
Thanks,
Arun
Bookmarks