Oct 15 2019 11:23 PM
Hi,
I'm using an excel formula which on Evaluation through comExcel Object gives "-2146826273". If i reduce the length of the Excel formula then it evaluates perfectly.
The formula giving an error :
=LEFT(IF(LEFT(K6,7)="Level 1","LEV1",IF(LEFT(K6,7)="Level 2","LEV2",IF(LEFT(K6,7)="Level 3","LEV3",IF(LEFT(K6,7)="Level 4","LEV4",IF(LEFT(K6,4)="Core","CORE",IF(OR(K6="",K6="Declined",K6="Selected Level Description"),"","Unable to convert Health Plan Option from Psyon")))))),4)
The formula worked fine for me is :
=LEFT(IF(LEFT(K6,7)="Level 1","LEV1",IF(LEFT(K6,7)="Level 2","LEV2",IF(LEFT(K6,7)="Level 3","LEV3",IF(LEFT(K6,7)="Level 4","LEV4",IF(LEFT(K6,4)="Core","CORE",IF(OR(K6="",K6="Declined",K6="Selected Level Description"),"","U")))))),4)
Can you please let me know the reason for the above observed behavior.
Note: If I put formula directly in Excel cell then both formulas worked fine.
Thanks & Regards
Ajay Kumar