Novice Techie

Microsoft Office Excel formulas and functions

In Microsoft Excel, formulas is used to perform mathematical calculations using the values in cells and to identify the relationships between the cells. All formulas in MS Excel must begin with an equals sign (=).

Microsoft Office Excel Formula

SUM

In Excel, SUM functions is used to sum the values in a range of cells or a cell.

Example for Excel SUM formula

To get sum of values from the cell A2 to A9. Click on cell which you want to display the sum value and put this formula in that cell.

Syntax for Excel SUM functions

=SUM (number1, [number2], ...)

=SUM(A2:A9)

IF

IF formula in excel function is used to perform the logical comparison between a value and what you expect. An IF formula in excel function will return the two values one is TRUE and another one is FALSE

Syntax for IF function

=IF (logical_test, [value_if_true], [value_if_false])

=IF(B2>70,"PASS","FAIL") 

COUNTIF function in excel

COUNTIF function used to count the number of cells that meet a particular condition in a range of cells. COUNTIF function can be used to count the cells that contains the date, numbers and text.

=COUNTIF(range of cells,condition)

=COUNTIF(C2:C6,"PASS")

Percentage

To apply the Percentage format for a cell or group of cells, select the cell or group of cells which you want to apply the Percentage format and from the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.

Subtraction

Minus (-) symbol is used to perform the subtraction task in excel. All formulas in Microsoft Excel must begin with an equals sign (=). Use an equals sign (=) to start the subtraction formula.

=A2-B2

=100-13

Multiplication

Asterisk (*) symbol is used to perform the multiplication task in excel. All formulas in Excel must begin with an equals sign (=). Use an equals sign (=) to start the multiplication formula.

=A2*B2

=100*13

Division

Forward slash (/) symbol is used to perform the division task in excel. All formulas in MS Excel must begin with an equals sign (=). Use an equals sign (=) to start the division formula.

=A2/B2

=100/13

Please visit other related articles

How to use Microsoft Office Excel: How to find duplicates in Excel
How to use Microsoft Office Excel: How to set default font in MS EXCEL?
How to use Microsoft Office Excel: Sorting and filtering in Excel
How to use Microsoft Office Excel: Excel formula guide for beginners