Accounting Excel Function (BYU Junior Core)

HLOOKUP

Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number

INDEX

Returns either the value or the reference to a value from a table or range

TRANSPOSE

Returns a transposed range of cells

VLOOKUP

Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position

XLOOKUP

Performs a lookup (either vertical or horizontal)

CONCAT

Used to join 2 or more strings together

FIND

Returns the location of a substring in a string (case-sensitive)

LEFT

Extract a substring from a string, starting from the left-most character

LEN

Returns the length of the specified string

LOWER

Converts all letters in the specified string to lowercase

MID

Extracts a substring from a string (starting at any position)

NUMBERVALUE

Returns a text to a number specifying the decimal and group separators

PROPER

Sets the first character in each word to uppercase and the rest to lowercase

REPLACE

Replaces a sequence of characters in a string with another set of characters

RIGHT

Extracts a substring from a string starting from the right-most character

SEARCH

Returns the location of a substring in a string

TRIM

Returns a text value with the leading and trailing spaces removed

UPPER

Convert text to all uppercase

VALUE

Converts a text value that represents a number to a number

DATE

Returns the serial date value for a date

DATEDIF

Returns the difference between two date values, based on the interval specifiedx

DAY

Returns the day of the month (a number from 1 to 31) given a date value

DAYS

Returns the number of days between 2 dates

HOUR

Returns the hours (a number from 0 to 23) from a time value

MINUTE

Returns the minutes (a number from 0 to 59) from a time value

MONTH

Returns the month (a number from 1 to 12) given a date value

NOW

Returns the current system date and time

SECOND

Returns the seconds (a number from 0 to 59) from a time value

TIME

Returns a decimal number given an hour, minute and second value

TODAY

Returns the current system date

WEEKDAY

Returns a number representing the day of the week, given a date value

WEEKNUM

Returns the week number for a date

YEAR

Returns a four-digit year (a number from 1900 to 9999) given a date value

CEILING

Returns a number rounded up based on a multiple of significance

FLOOR

Returns a number rounded down based on a multiple of significance

INT

Returns the integer portion of a number

RAND

Returns a random number that is greater than or equal to 0 and less than 1

RANDBETWEEN

Returns a random number that is between a bottom and top range

ROUND

Returns a number rounded to a specified number of digits

ROUNDDOWN

Returns a number rounded down to a specified number of digits

ROUNDUP

Returns a number rounded up to a specified number of digits

SIGN

Returns the sign of a number

SUBTOTAL

Returns the subtotal of the numbers in a column in a list or database

SUM

Adds all numbers in a range of cells

SUMIF

Adds all numbers in a range of cells based on one criteria

SUMIFS

Adds all numbers in a range of cells, based on a single or multiple criteria

AVERAGE

Returns the average of the numbers provided

AVERAGEIF

Returns the average of all numbers in a range of cells, based on a given criteria

AVERAGEIFS

Returns the average of all numbers in a range of cells, based on multiple criteria

COUNT

Counts the number of cells that contain numbers as well as the number of arguments that contain numbers

COUNTBLANK

Counts the number of empty cells in a range

COUNTIF

Counts the number of cells in a range, that meets a given criteria

COUNTIFS

Counts the number of cells in a range, that meets a single or multiple criteria

MEDIAN

Returns the median of the numbers provided

MIN

Returns the smallest value from the numbers provided

RANK

Returns the rank of a number within a set of numbers

STDEV

Returns the standard deviation of a population based on a sample of numbers

AND

Returns TRUE if all conditions are TRUE

IF

Returns one value if the condition is TRUE or another value if the condition is FALSE

IFERROR

Used to return an alternate value if a formula results in an error

IFNA

Used to return an alternate value if a formula results in #N/A error

IFS

Specify multiple IF conditions within 1 function

NOT

Returns the reversed logical value

OR

Returns TRUE if any of the conditions are TRUE

ISBLANK

Used to check for blank or null values

ISNA

Used to check for #N/A error

ISNUMBER

Used to check for a numeric value

FV

Returns the future value of an investment

IPMT

Returns the interest payment for an investment

ISPMT

Returns the interest payment for an investment

NPER

Returns the number of periods for an investment

NPV

Returns the net present value of an investment

PMT

Returns the payment amount for a loan

PV

Returns the present value of an investment

RATE

Returns the interest rate for an annuity