<div>
It means that the formula for showing data in the active cell uses the average of the previous two cells in the same row.
</div>


It means that the formula for showing data in the active cell uses the average of the previous two cells in the same row.

<div>
Do you mean to say RC(-1) is previous cell and RC(-2) is previous to RC(-1)?
</div>


Do you mean to say RC(-1) is previous cell and RC(-2) is previous to RC(-1)?

<div>
<div class="content wysiwyg-content">
I am working on a vb.net application which generates an excel spread, can anyone tell me what does this mean<br />
ActiveCell.FormulaR1C1 = &quot;=Average(RC[-1],RC[-2])&quot;<br />

</div>
</div>


I am working on a vb.net application which generates an excel spread, can anyone tell me what does this mean
ActiveCell.FormulaR1C1 = "=Average(RC[-1],RC[-2])"


What does this does this expression mean ActiveCell.FormulaR1C1 = &quot;=Average(RC[-1],RC[-2])&quot;

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

What does this does this expression mean ActiveCell.FormulaR1C1 = &quot;=Average(RC[-1],RC[-2])&quot;

What does this does this expression mean ActiveCell.FormulaR1C1 = "=Average(RC[-1],RC[-2])"