_Excel_RangeWrite Not working

[SkysLastChance]

Stuck here scratching my head again.

I am trying to write a formula    =IF(AND(X2="X",Y2=""),1,"")   to the B2 cell in excel. 

However, my code does not put anything in.  I also don't get any errors. 

#include <Excel.au3>

Local $oWorkbook

$oExcel = _Excel_Open()

$sWorkbook = @ScriptDir & "\VitalSite" & " " & @Mon & "_" & @MDAY & "_"  & @Year & ".xlsx"

$oWorkbook = _Excel_BookOpen($oExcel,$sWorkbook)

_Excel_RangeWrite($oWorkbook,Default, '=IF(AND(X' & 2 & '="X",Y' & 2 & '=""),1,"Hello"', "B" & 2)

 

 

[Subz]

Try:

_Excel_RangeWrite($oWorkbook,Default, '=IF(AND(X' & 2 & '="X",Y' & 2 & '=""),1,"Hello")', "B" & 2)

 

[Nine]

over complicated, try :

_Excel_RangeWrite($oWorkbook,Default, '=IF(AND(X2="X",Y2=""),1,"Hello")', "B2")

FYI formula may differ depending on Office language. Mine is french, so formulas use french word and different delimiter...