Hi People,
Could you give me a hand? I am trying to break the following one line code into two lines but am not able to do it.
![]()
ActiveCell.FormulaR1C1 = _ "=IF(AND(RC[-5]=""EM0040035"",RC[-1]=0),800,IF(AND(RC[-5]=""EM0040088"",RC[-1]=0),570,IF(AND(RC[-5]=""EM0040075"",RC[-1]=0),680,""""))"""
Bookmarks