Dear All,
The function not working kindly help.
The function not working kindly help.
Limit | Days | |
10,00,000.00 | 120 | IF(A3<2500000,IF(B2<=90,"Personal Visits",IF(AND(B2>90,B2<121),"Increase Frequency of personal visits",IF(AND(B2>120,B2<181),"Issue Registered Recall Notices",IF(AND(B2>180),"Initiate Legal Suit",0))))),IF(A3>2500000,IF(B2<=90,"Personal Visits",IF(AND(B2>90,B2<121),"Issue Registered Recall Notices",IF(B2>120,"Initiate Legal Suit",0)))) |
25,00,000.00 |