COMPUTER COURSES

Using AND, OR with IF Function

Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.

Use the OR function, one of the logical functions, to determine if any conditions in a test are TRUE.

Download the Lesson and Example file in Khmer

 

excel-if-or

Continue reading “Using AND, OR with IF Function”

Advertisements
COMPUTER COURSES · MS Excel

Using RANK Function

Description

RankFunctionReturns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)

IMPORTANT:¬†This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. Continue reading “Using RANK Function”

COMPUTER COURSES · MS Excel

Using SUM and Average Functions

SumFunctionApplies To: Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Online, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel Starter, Excel Mobile, Excel for Android phones.

SUM Function

The SUM function, one of the math and trig functions, adds values. You can add individual values, cell references or ranges or a mix of all three. 

Continue reading “Using SUM and Average Functions”

COMPUTER COURSES · MS Excel

Using COUNTIF and COUNTIFS function

CountIfApplies To: Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Online, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel Starter, Excel Mobile, Excel for Android phones.

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

COUNTIFS applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

Continue reading “Using COUNTIF and COUNTIFS function”