S
Slickuser
I try to calculate the standard deviation of average of C2:C35.
But I get random range in the worksheet G$i. It's not showing as:
D2 =STDEVA(C2:C35,D2)
D3 =STDEVA(C2:C35,D3)
......
It's showing as:
D2 =STDEVA(C2:C35,D2)
D3 =STDEVA(C2:C31,D3)
D4 =STDEVA(C2:C33,D4)
......
Any one know why? I tried with " " doesn't help and q { } show nothing
since it's like ' '.
Thanks.
my $lastRowStd = 35;
my $i=2;
while($i<=$lastRowStd)
{
$Range = $CurrentSheet->Range("G$i");
$Range->{Value} = qq {=STDEVA(C2:C$lastRowStd,D$i)};
$i++;
}
But I get random range in the worksheet G$i. It's not showing as:
D2 =STDEVA(C2:C35,D2)
D3 =STDEVA(C2:C35,D3)
......
It's showing as:
D2 =STDEVA(C2:C35,D2)
D3 =STDEVA(C2:C31,D3)
D4 =STDEVA(C2:C33,D4)
......
Any one know why? I tried with " " doesn't help and q { } show nothing
since it's like ' '.
Thanks.
my $lastRowStd = 35;
my $i=2;
while($i<=$lastRowStd)
{
$Range = $CurrentSheet->Range("G$i");
$Range->{Value} = qq {=STDEVA(C2:C$lastRowStd,D$i)};
$i++;
}