Using VBA and FormulaLocal "@" is added automatically and the formula changes the output.

%3CLINGO-SUB%20id%3D%22lingo-sub-2404653%22%20slang%3D%22de-DE%22%3EUsing%20VBA%20and%20FormulaLocal%20%22%40%22%20is%20added%20automatically%20and%20the%20formula%20changes%20the%20output.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2404653%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI'm%20trying%20to%20add%20a%20formula%20via%20VBA%20and%20.FormulaLocal%20into%20a%20worksheet.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Formula%20is%20simple%20and%20as%20follows%3A%20%22%3DAVERAGE(IF(ISNUMBER(E8%3AE11)%3B%20E8%3AE11%3B0))%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20enter%20it%20manually%20it%20works%20perfectly.%26nbsp%3B%3C%2FP%3E%3CP%3EAlthough%20if%20I%20enter%20it%20via%20VBA%20the%20character%20%22%40%22%20(implicit%20interception%20operator)%20is%20added%20automatically%20and%20the%20formula%20changes%20into%3A%20%22%22%3DAVERAGE(IF(ISNUMBER(%40E8%3AE11)%3B%20E8%3AE11%3B0))%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Output%20of%20the%20formula%20including%20%22%40%22%20is%20different%20(0%20instead%20of%20some%20percentage)%20although%20in%20the%20Help%20Popup%20it%20says%20that%20the%20output%20is%20not%20altered%20by%20the%20additional%20%22%40%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2404653%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello, 

I'm trying to add a formula via VBA and .FormulaLocal into a worksheet. 

The Formula is simple and as follows: "=AVERAGE(IF(ISNUMBER(E8:E11);E8:E11;0))"

 

When I enter it manually it works perfectly. 

Although if I enter it via VBA the character "@" (implicit interception operator) is added automatically and the formula changes into: ""=AVERAGE(IF(ISNUMBER(@E8:E11);E8:E11;0))"

 

The Output of the formula including "@" is different (0 instead of some percentage) although in the Help Popup it says that the output is not altered by the additional "@"

0 Replies