The following formulas are currently supported in Wdesk. You can also view formulas within Wdesk using the **Formula Assistant** in the Formula Bar.

## Date functions

Formula |
Description |

DATE | Returns a date from a given year, month, and day |

DATEVALUE | Returns a serial number based on a date written in MM/DD/YYYY format |

DAY | Returns the day of the month for a date |

DAYS | Returns the number of days between two dates |

DAYS360 | Returns the number of days between two dates based on a 360-day year (twelve 30-day months) |

EDATE | Returns the serial date that is the indicated number of months before or after a specified date |

EO MONTH | Returns the end of the month for a given date, offset by a number of months |

MONTH | Returns the month of the year for a date |

NETWORKDAYS | Returns the number of whole working days between two dates |

NETWORKDAYS.INTL | Returns the number of whole working days between two dates with custom weekends and holidays |

WEEKDAY | Returns the day of the week corresponding to a date |

WORKDAY | Returns the serial date before or after a specified number of workdays |

WORKDAY.INTL | Returns the serial date before or after a specified number of workdays with custom weekend parameters |

YEAR | Returns the year for a date |

YEARFRAC | Calculates the fraction of the year represented by the number of whole days between two dates |

## Financial calculation functions

Formula |
Description |

FV | Calculates the future value of an investment based on constant interest rate |

IRR | Calculates internal rate of return for a regular series of cash flows |

NPV | Calculates the net present value of an investment using discount rates, payments, and income |

PMT | Calculates payment on a loan given constant interest rate and payments |

PV | Calculates the present value of an investment based on a constant interest rate. |

## Information gathering functions

Formula |
Description |

COUNT | Counts the number of numeric values in a set of values |

COUNTA | Counts the number of non-blank values in a set of values |

COUNTBLANK | Counts the number of blank values in a set of values |

COUNTIF | Counts the number of cells in a range that meet a certain condition |

COUNTIFS | Counts the number of cells in a range that meet a set of conditions |

ISBLANK | Returns TRUE or FALSE if the selection is empty |

ISERROR | Returns TRUE if the value is an error; otherwise returns FALSE |

ISNA | Returns TRUE or FALSE if the selection is #N/A |

ISNUMBER | Returns TRUE or False if the selection is a number |

VALUE | Returns a numerical value for a given text string representing a number or date |

## Lookup functions

Formula |
Description |

HLOOKUP | Finds given value in a row then returns a value from that column |

INDEX | Returns the value at the specified row/column coordinate |

MATCH | Finds an index in a one-dimensional range |

VLOOKUP | Finds given value in a column then returns a value from that row |

## Logical functions

Formula |
Description |

AND | Returns TRUE if all arguments are TRUE; otherwise returns FALSE |

CHOOSE | Uses index_num to return a value from the list of value arguments |

IF | Returns one value if a condition specified is TRUE and another value if it is FALSE |

IFERROR | Returns value if it is not an error; otherwise, returns value_if_error |

IFNA | Returns an alternate value if the first value is #N/A |

IFS | Checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition |

NOT | Returns FALSE if the expression is TRUE; Returns TRUE if the expression is FALSE |

OR | Returns TRUE if any arguments are TRUE; returns FALSE if all arguments are FALSE |

## Mathematical functions

Formula |
Description |

ABS | Returns the absolute value of a number |

EXP | Returns e raised to the power of number |

LN | Returns the natural logarithm of a number |

MOD | Returns the remainder from a division |

POWER | Returns the result of an exponentiation |

PRODUCT | Multiplies all the numbers in a selection of cells |

SIGN | Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative |

SQRT | Returns a positive square root |

SUBTOTAL | Create a total from given values using the specified operation, ignoring any subtotals in the range |

SUM | Adds all the numbers in a selection of cells |

SUMIF | Adds the cells according to a condition in a corresponding range |

SUMIFS | Adds the cells according to a set of conditions in corresponding ranges |

SUMPRODUCT | Multiplies corresponding components in equal-sized ranges and returns the sum of the products |

## Rounding functions

Formula |
Description |

INT | Rounds a number down to the nearest integer |

MROUND | Returns a number rounded to the desired multiple |

ROUND | Rounds a number to a specified number of digits |

ROUNDDOWN | Rounds a number down |

ROUNDUP | Rounds a number up |

TRUNC | Truncates a number to a specific number of digits |

## Text creation functions

Formula |
Description |

CONCATENATE | Joins several text strings into one text string |

CONCATENATEIF | Joins cells with a separator according to a condition in a range |

CHAR | Returns the character associated with the given character code |

FIND | Returns the starting position of text within a string |

LEFT | Returns the first character or characters in some text |

LEN | Returns the number of characters in the argument |

LOWER | Returns the text with all characters in lowercase |

MID | Returns a selected portion of text |

PROPER | Returns the text with only the first letter in each word capitalized |

REPT | Repeats text a given number of times |

RIGHT | Returns the last character in some text |

SEARCH | Returns the starting position of text within a string |

SUBSTITUTE | Substitutes specific characters of the text with new text |

TEXT | Formats the given number as text by the format string |

TRIM | Removes excess whitespace from text |

UPPER | Returns the text with all characters capitalized |

## Statistical functions

Formula |
Description |

AVERAGE | Returns the average (arithmetic mean) of a set |

AVERAGEA | Finds the arithmetic mean of a set including text and logical values |

AVERAGEIFS | Returns the average of all cells that meet multiple criteria |

LARGE | Returns the n-th largest value from a range |

MAX | Returns the largest number in a set of values |

MAXA | Returns the largest value in a set including text and logical values |

MAXIFS | Returns the maximum value of all cells that meet multiple criteria |

MEDIAN | Returns the statistical median of a given set of numbers |

MIN | Returns the smallest number in a set of values |

MINA | Returns the smallest value in a set including text and logical values |

MINIFS | Returns the minimum value of all cells that meet multiple criteria |

RANK | Returns the rank of a given value in a corresponding range |

RANK.AVG | Returns the statistical average of the rank of a given value in a corresponding range |

RANK.EQ | Returns the statistical rank of a given value in a corresponding range |

SMALL | Returns the n-th smallest value from a range |

STDEV | Returns the standard deviation for a given set of values within a sample |

STDEVA | Returns the standard deviation for a given set of values within a sample, where text or FALSE=0 and TRUE=1 |

STDEVPA | Returns the standard deviation for a given set of values within an entire population, where text or FALSE=0 and TRUE=1 |

STDEV.S | Returns the standard deviation for a given set of values within a sample |

STDEV.P | Returns the sample standard deviation for a given set of values for an entire population |