HRESULT: 0x800A03EC at implementing a formula

Question

I'm trying to add a formula to a cell in excel via powershell but get an error

HRESULT: 0x800A03EC

I tried a lot of things including setting calculations to manual ($Excel.Calculation = -4153) but still get the same result. maybe I'm overlooking things or thinking to hard. Does somebody can help me whit this?

$i = 8
[String]$formula = "=IF(D$i>0;(I$i+L$i+Z$i+AA$i+J$i+K$i)/D$i;0)" 
$Excel_ws.Cells.Item( $i , 15 ).formula =  $formula

that was totaly the thing in this case..... adding the formula whit a separator , instead of ; — hexedecimal, Sep 16 '20 at 13:33

score 0 · Accepted Answer · answered Sep 16 '20 at 13:26

0

Similar to this question:

If you are using .formula, then the formula separator should be , and not ;
```
"=IF(D$i>0,(I$i+L$i+Z$i+AA$i+J$i+K$i)/D$i,0)"
```
Otherwise, you can keep the ; and use .formulalocal instead of .formula.

answered Sep 16 '20 at 13:26

BigBen

46,229
7
24
40

1

that was totaly the thing in this case..... adding the formula whit a separator , instead of ; – hexedecimal Sep 16 '20 at 13:35

HRESULT: 0x800A03EC at implementing a formula

1 Answers1