Hi,
Can you please help correct structure of the VBA code on my Excel sheet?
I presently have (with MR EXCEL's help in the past) :
Cells(c.Row, "J").Formula = "=IF(LEFT(RC[-1],1)<> RC[-2],""ALERT"","""")"
I'm trying to modify it by adding an AND function to catch if the most left character in ColI (RC[-1],1) has the letter R then instead of showing "ALERT" it should show "NS".
The code I've tried but isn't working is: Cells(c.Row, "J").Formula = "=IF(AND(LEFT(RC[-1],1)<> ""R"",LEFT(RC[-1],1)<>RC[-2],""ALERT"",IF(LEFT(RC[-1],1)= ""R"",""NS"","""")"
Can you please help correct this?
Can you please help correct structure of the VBA code on my Excel sheet?
I presently have (with MR EXCEL's help in the past) :
Cells(c.Row, "J").Formula = "=IF(LEFT(RC[-1],1)<> RC[-2],""ALERT"","""")"
I'm trying to modify it by adding an AND function to catch if the most left character in ColI (RC[-1],1) has the letter R then instead of showing "ALERT" it should show "NS".
The code I've tried but isn't working is: Cells(c.Row, "J").Formula = "=IF(AND(LEFT(RC[-1],1)<> ""R"",LEFT(RC[-1],1)<>RC[-2],""ALERT"",IF(LEFT(RC[-1],1)= ""R"",""NS"","""")"
Can you please help correct this?