hgh

=COUNTA(value1, [value2], …)

Definition: Counts the number of cells in a range of cells that are not blank.

=RATE(nper, pmt, pv)

Definition: Calculates the interest rate earned for an investment.

=EFFECT(nominal_rate, npery)

Definition: Calculates the annual percentage rate for an interest rate.

=NPER(rate, pmt, pv)

Definition: Calculates the number of payments that will be made to pay off a loan.

=PMT(rate, nper, pv)

Definition: Calculates the payment amount for a loan.

=PV(rate, nper, pmt)

Definition: Calculates the current value of an investment (accounting for compound interest).

=FV(rate, nper, pmt)

Definition: Calculates the future value of an investment.

=AND(logical1, [logical2], …)

Definition: Combines Boolean expressions to determine if ALL of the combined expressions are TRUE

=OR(logical1, [logical2], …)

Definition: Combines Boolean expressions to determine if ANY of the combined expressions are TRUE

=NOT(logical1, [logical2], …)

Definition: Check to see if a Boolean expression is not evaluated as TRUE

=IF(logical_test, value_if_true, value_if_false

efinition: Build on Boolean logic and specify the results depending on the results of the Boolean expression.

=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

Definition: Returns the related value from the specified column after finding the match in the first column.

=HLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

Definition: Returns the related value from the specified row after finding the match in the first row

=LEN(text)

Definition: The length, in number of characters, of a block of text.

=SEARCH(find_text, within_text)

Definition: The position of a specific character, word, or phrase within a block of text.

=LEFT(text, [num_chars])

Definition: Returns the specified number of characters starting from the beginning of a block of text

=MID(text, start_num, num_chars)

Definition: Returns the specified number of characters from the middle of a block of text.

=RIGHT(text, [num_chars]

Definition: Returns the specified number of characters starting from the end of a block of text

=CONCATENATE(text1, [text2], …

Definition: Combines blocks of text.

=STDEV.S(number1, [number2], …)

Definition: Calculates the standard deviation for a sample. (Use STDEV.P to calculate the standard deviation for a population

=CONFIDENCE.NORM(alpha, standard_dev, size)

Definition: The confidence interval or range of values that we believe the “true” population value falls into

=CORREL(array1, array2

Definition: Calculates the correlation coefficient between two sets of values.

=FORECAST(X, known_y’s, known_x’s)

Definition: Calculates, or predicts, a future value along a linear trend by using existing values