Tutorial by Examples

Detailed instructions on excel-formula(s). There are many formulas that you can choose from. They are divided up into 7 different categories and are on the FORMULAS tab in Excel. The categories are: Financial Logical Text Date & Time Lookup & Reference Math & trig More Function...

Excel formulas are used to process simple or complex equations and output the result to a specific cell within a worksheet. (There is an exception to this where the WorksheetFunction class is used in VBA programming, however VBA is out of scope for this tag - please refer to the excel-vba or vba ...

There is no additional installation required for excel-formula on top of what is already required for excel. Please refer to excel documentation.

ColumnColumn AExample formulaExample formulaRow 12Row 23Row 35=A1+A2=Sum(A1,A2)

You can use cell references without row numbers. For instance, the formula =sum(C:C) will add up all the values in column C of the active sheet. This is helpful when you are adding and removing rows but don't want to update your formulas each time. There are some instances when using this whole co...