# Formula Utility Methods

The following example shows some GemBox.Spreadsheet utility methods that can be useful for creating formulas.

``````using System;

class Program
{
static void Main()
{
// If using the Professional version, put your serial key below.

var workbook = new ExcelFile();
var worksheet = workbook.Worksheets.Add("Formula Utility Methods");

// Fill first column with values.
for (int i = 0; i < 10; i++)
worksheet.Cells[i, 0].Value = i + 1;

// Cell B1 has formula '=A1*2', B2 '=A2*2', etc.
for (int i = 0; i < 10; i++)
worksheet.Cells[i, 1].Formula = String.Format("={0}*2", CellRange.RowColumnToPosition(i, 0));

// Cell C1 has formula '=SUM(A1:B1)', C2 '=SUM(A2:B2)', etc.
for (int i = 0; i < 10; i++)
worksheet.Cells[i, 2].Formula = String.Format("=SUM(A{0}:B{0})", ExcelRowCollection.RowIndexToName(i));

// Cell A12 contains sum of all values from the first row.
worksheet.Cells["A12"].Formula = String.Format("=SUM(A1:{0}1)", ExcelColumnCollection.ColumnIndexToName(worksheet.Rows[0].AllocatedCells.Count - 1));

workbook.Save("Formula Utility Methods.%OutputFileType%");
}
}``````
``````Imports System

Module Program

Sub Main()

' If using the Professional version, put your serial key below.

Dim workbook As New ExcelFile()
Dim worksheet = workbook.Worksheets.Add("Formula Utility Methods")

' Fill first column with values.
For i = 0 To 9 Step 1
worksheet.Cells(i, 0).Value = i + 1
Next

' Cell B1 has formula '=A1*2', B2 '=A2*2', etc.
For i = 0 To 9 Step 1
worksheet.Cells(i, 1).Formula = String.Format("={0}*2", CellRange.RowColumnToPosition(i, 0))
Next

' Cell C1 has formula '=SUM(A1:B1)', C2 '=SUM(A2:B2)', etc.
For i = 0 To 9 Step 1
worksheet.Cells(i, 2).Formula = String.Format("=SUM(A{0}:B{0})", ExcelRowCollection.RowIndexToName(i))
Next

' Cell A12 contains sum of all values from the first row.
worksheet.Cells("A12").Formula = String.Format("=SUM(A1:{0}1)", ExcelColumnCollection.ColumnIndexToName(worksheet.Rows(0).AllocatedCells.Count - 1))

workbook.Save("Formula Utility Methods.%OutputFileType%")
End Sub
End Module``````