1. Calculation functions
  2. Functions
  3. Excel comparison

This guide provides comparisons of all Microsoft Excel functions to those available in the Excel add-in.

Some Excel functions are directly comparable with Anaplan functions.

A

Excel functionExcel descriptionAnaplan solution
ABSReturns the absolute value of a number.Use the ABS function.
ACCRINTReturns the accrued interest for a security that pays interest on a periodic basis.See the Financial Functions.
ACCRINTMReturns the accrued interest for a security that pays interest at maturity.See the Financial Functions.
ACOSReturns the arccosine (in radians) of a number.There is no native Anaplan function.
ACOSHReturns the inverse hyperbolic cosine of a number.There is no native Anaplan function.
ADDRESSReturns a text representation of a cell address.Use the NAME function.
AGGREGATEApply functions such as AVERAGE, SUM, COUNT, MAX or MIN and ignores errors or hidden rows.Anaplan aggregates this as part of the module functionality. Set the aggregation level in the module.
AMORDEGRCReturns the linear depreciation of an asset for each accounting period, on a prorated basis.See the Financial Functions.
AMORLINCReturns the depreciation of an asset for each accounting period, on a prorated basis.See the Financial Functions.
ANDReturns TRUE if all of its arguments are TRUE.Use operators and constants with your data to create calculations and find the data you need.
AREASReturns the number of ranges in a reference.There is no native Anaplan function.
ASINReturns the arcsine (in radians) of a number.There is no native Anaplan function.
ASINHReturns the inverse hyperbolic sine of a number.There is no native Anaplan function.
ATANReturns the arctangent (in radians) of a number.There is no native Anaplan function.
ATAN2Returns the arctangent (in radians) of (x,y) coordinates.There is no native Anaplan function.
ATANHReturns the inverse hyperbolic tangent of a number.There is no native Anaplan function.
AVEDEVReturns the average of the absolute deviations of the numbers provided.There is no native Anaplan function, but can be built using a calculation.
AVERAGEReturns the average of the numbers provided.Use the x[AVERAGE:y] function.
AVERAGEAReturns the average of the numbers provided and treats TRUE as 1 and FALSE as 0.There is no native Anaplan function.
AVERAGEIFReturns the average of all numbers in a range of cells, based on a criterion.Use the x[AVERAGE:y] function to calculate the average for a specified range of values.
AVERAGEIFSReturns the average of all numbers in a range of cells, based on multiple criteriaUse the x[AVERAGE:y] function to calculate the average for a specified range of values.

B

Excel functionExcel descriptionAnaplan solution
BETA.DISTReturns the beta distribution.There is no native Anaplan function.
BETA.INVReturns the inverse of the cumulative beta probability density function.There is no native Anaplan function.
BETADISTReturns the cumulative beta probability density function.There is no native Anaplan function.
BETAINVReturns the inverse of the cumulative beta probability density function.There is no native Anaplan function, but can be built using a calculation.
BIN2DECConverts a binary number to a decimal number.There is no native Anaplan function, but can be built using a calculation.
BIN2HEXConverts a binary number to a hexadecimal number.There is no native Anaplan function, but can be built using a calculation.
BIN2OCTConverts a binary number to an octal number.There is no native Anaplan function, but can be built using a calculation.
BINOM.DISTReturns the individual term binomial distribution probability.There is no native Anaplan function, but can be built using a calculation.
BINOM.INVReturns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion.There is no native Anaplan function, but can be built using a calculation.
BINOMDISTReturns the individual term binomial distribution probability.There is no native Anaplan function, but can be built using a calculation.

C

Excel functionExcel descriptionAnaplan solution
CEILINGReturns a number rounded up based on a multiple of significance.Use the MROUND function to round up to the nearest desired multiple.
CEILING.PRECISEReturns a number rounded up to the nearest integer or to the nearest multiple of significance.Use the MROUND function to round up to the nearest desired multiple.
CELLUsed to retrieve information about a cell (e.g. contents, formatting, size).There is no native Anaplan function.
CHARReturns the character based on the ASCII value.There is no native Anaplan function.
CHIDISTReturns the one-tailed probability of the chi-squared distribution.There is no native Anaplan function, but can be built using a calculation.
CHIINVReturns the inverse of the one-tailed probability of the chi-squared distribution.There is no native Anaplan function, but can be built using a calculation.
CHITESTReturns the value from the chi-squared distribution.There is no native Anaplan function, but can be built using a calculation.
CHOOSEReturns a value from a list of values based on a given position.Use the FINDITEM function to match text to an item in a list, or match text to an item in a time period list. This can match on an item name or code.
CLEANRemoves all non-printable characters from a string.There is no native Anaplan function.
CODEReturns the ASCII value of a character or the first character in a cell.Use the CODE function to enter several conditions, and the AND function to test if all conditions are met.
COLUMNReturns the column number of a cell reference.Use the ITEM calculation function.
COLUMNSReturns the number of columns in a cell reference.There is no native Anaplan function, but can be built using a calculation.
COMBINReturns the number of combinations for a specified number of items.There is no native Anaplan function, but can be built using a calculation.
COMBINAReturns the number of combinations for a specified number of items and includes repetitions.There is no native Anaplan function, but can be built using a calculation.
COMPLEXConverts coefficients (real and imaginary) into a complex number.There is no native Anaplan function, but can be built using a calculation.
CONCATJoins two or more strings together.Use the & operator to concatenates two or more text strings.
CONCATENATEJoins two or more strings together. This has been replaced by CONCAT function.Use the & operator to concatenates two or more text strings.
CONCATENATE with &Joins two or more strings together using the & operator.Use the & operator to concatenates two or more text strings.
CONVERTConvert a number from one measurement unit to another measurement unit.Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item.
COSReturns the cosine of an angle.There is no native Anaplan function, but can be built using a calculation.
COSHReturns the hyperbolic cosine of a number.There is no native Anaplan function, but can be built using a calculation.
COUNTCounts the number of cells that contain numbers as well as the number of arguments that contain numbers.Use an IF THEN statement with a SUM function to accomplish the same goals. Use IF THEN ELSE to create a count, then use SUM to get the total for that line item.
COUNTACounts the number of cells that are not empty as well as the number of value arguments provided.Combine an IF THEN statement with a SUM function to accomplish the same goal.
COUNTBLANKCounts the number of empty cells in a range.Combine an IF THEN statement with a SUM function to accomplish the same goal.
COUNTIFCounts the number of cells in a range, that meets the specified criteria.Combine an IF THEN statement with a SUM function to accomplish the same goal.
COUNTIFSCounts the number of cells in a range, that meets a single or multiple criteria.Combine an IF THEN statement with a SUM function to accomplish the same goal.
COUPDAYBSReturns the number of days from the beginning of a coupon period until its settlement date.Use the COUPDAYBS function.
COUPDAYSReturns the number of days in the coupon period that contains the settlement date.Use the COUPDAYS function.
COUPDAYSNCReturns the number of days from the settlement date to the next coupon date.Use the COUPDAYSNC function.
COUPNCDReturns a number that represents the next coupon date after the settlement date.Use the COUPNCD function.
COUPNUMReturns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.Use the COUPNUM function.
COUPPCDReturns a number that represents the previous coupon date before the settlement date.Use the COUPPCD function.
COVARReturns the covariance, the average of the products of deviations for two data sets.There is no native Anaplan function, but can be built using a calculation.

D

Excel functionExcel descriptionAnaplan solution
DATEReturns the serial date value for a date.Use the DATE function to convert numbers yyyy, mm, and dd into a date. The date format depends on your locale.
DATEDIFReturns the difference between two date values, based on the interval specified.Use the DECUMULATE function to calculate the difference in a value in the current period vs previous period.
DATEVALUEReturns the serial number of a date.Use Date Settings.
DAVERAGEAverages all numbers in a column in a list or database, based on specified criteria.Use the AVERAGE summary method.
DAYReturns the day of the month (a number from 1 to 31) given a date value.Use the DAY function to convert a date into a day in number format. The date format depends on your locale.
DAYSReturns the number of days between two dates.Use the DAYS function to return the number of days in a time period. You can use a single time period parameter or no parameter to return the number of days in a time period.
DAYS360Returns the number of days between two dates based on a 360-day year.Use the DAYS function to return the number of days in a time period. You can use a single time period parameter or no parameter to return the number of days in a time period.
DBReturns the depreciation of an asset based on the fixed-declining balance method.See the Financial Functions.
DCOUNTReturns the number of cells in a column or database that contains numeric values and meets a given criteria.Use the SUM function.
DCOUNTAReturns the number of cells in a column or database that contains non-blank values and meets a given criteria.Use the SUM function.
DDBReturns the depreciation of an asset based on the double-declining balance method.See Financial Functions.
DEGREESConverts radians into degrees.There is no native Anaplan function, but can be built using a calculation.
DGETRetrieves from a database a single record that matches a given criteria.Use the ITEM function.
DMAXReturns the largest number in a column in a list or database, based on the specified criteria.Use the x[MAX:y] function.
DMINReturns the smallest number in a column in a list or database, based on the specified criteria.Use the x[MIN:y] function.
DOLLARConverts a number to text, using a currency format.There is no native Anaplan function, but can be built using a calculation.
DPRODUCTReturns the product of the numbers in a column in a list or database, based on the  specified criteria.There is no native Anaplan function, but can be built using a calculation.
DSTDEVReturns the standard deviation of a population based on a sample of numbers.There is no native Anaplan function, but can be built using a calculation.
DSTDEVPReturns the standard deviation of a population based on the entire population of numbers.There is no native Anaplan function, but can be built using a calculation.
DSUMSums the numbers in a column or database that meets the specified criteria.Use the SUM function.
DURATIONReturns the macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield.Use the DURATION function.
DVARReturns the variance of a population based on a sample of numbers.Use the SELECT and COLLECT functions with line items to calculate the variance.
DVARPReturns the variance of a population based on the entire population of numbers.Use the SELECT and COLLECT functions with line items to calculate the variance.

E

Excel functionExcel descriptionAnaplan solution
EDATEAdds a specified number of months to a date and returns the result as a serial date.Use the OFFSET function to return a value from a specified number of periods in advance.
EOMONTHCalculates the last day of the month after adding a specified number of months to a date.Use the END function.
ERROR.TYPEReturns the numeric representation of an Excel error.There is no native Anaplan function, but can be built using a calculation.
EVENRounds a number up to the nearest even integer.There is no native Anaplan function, but can be built using a calculation.
EXACTCompares two strings and returns TRUE if both values are the same.Use the COMPARE function to compares text values. The result is 0 if they match, 1 or -1 if not matched.
EXPReturns e raised to the nth power.Use the EXP function.

F

Excel functionExcel descriptionAnaplan solution
FACTReturns the factorial of a number.There is no native Anaplan function, but can be built using a calculation.
FALSEReturns a logical value of FALSE.Use a boolean argument.
FINDReturns the location of a substring in a string (case-sensitive).Use the FIND function to look for a text string in a text-formatted item, starting at a specified character number. The result is a number that denotes the character position.
FIXEDReturns a text representation of a number rounded to a specified number of decimal places.Use the VALUE function to convert a numeric value in a text field to a number format.
FLOORReturns a number rounded down based on a multiple of significance.There is no native Anaplan function, but can be built using a calculation.
FORECASTReturns a prediction of a future value based on existing values provided.Use the FV function.
FREQUENCYReturns how often values occur within a set of data. It returns a vertical array of numbers.There is no native Anaplan function, but can be built using a calculation.
FVReturns the future value of an investment.Use the FV function.

G

Excel functionExcel descriptionAnaplan solution
GROWTHReturns the predicted exponential growth based on existing values provided.Use the EXP function to distribute along the timeline.

H

Excel functionExcel descriptionAnaplan solution
HLOOKUPPerforms 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.Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item.
HOURReturns the hours (a number from 0 to 23) from a time value.There is no native Anaplan function, but can be built using a calculation.
HYPERLINKCreates a shortcut to a file or Internet address.Use the MAKELINK function to create a clickable URL.

I

Excel functionExcel descriptionAnaplan solution
IFReturns one value if the condition is TRUE, or another value if the condition is FALSE.Use an IF THEN ELSE conditional formula.
IF (more than 7)Nest more than seven IF functions.Use an IF THEN ELSE conditional formula.
IF (up to 7)Nest up to seven IF functions.Use an IF THEN ELSE conditional formula.
IFERRORUsed to return an alternate value if a formula results in an error.Use an IF THEN ELSE conditional formula.
IFNAUsed to return an alternate value if a formula results in #N/A error.Use an IF THEN ELSE conditional formula.
IFSSpecify multiple IF conditions within a function.Use an IF THEN ELSE conditional formula.
INDEXReturns either the value or the reference to a value from a table or range.Use the FINDITEM formula to match text to an item in a list, or in a time period list. Matches can be on the item name or code.
INDIRECTReturns the reference to a cell based on its string representation.Use the LOOKUP and TEXT formulas.
INFOReturns information about the operating environment.There is no native Anaplan function, but can be built using a calculation.
INTReturns the integer part of a number.Use module formatting.
INTERCEPTReturns the y-axis intersection point of a line using x-axis values and y-axis values.There is no native Anaplan function, but can be built using a calculation.
IPMTReturns the interest payment for an investment.Use the RATE formula to calculate a per period interest rate.
IRRReturns the internal rate of return for a series of cash flows.Use the IRR function.
ISBLANKChecks for blank or null values.Use the ISBLANK function.
ISERRChecks for error values except #N/A.There is no native Anaplan function, but can be built using a calculation.
ISERRORChecks for error values.There is no native Anaplan function, but can be built using a calculation.
ISLOGICALChecks for a logical value (TRUE or FALSE).There is no native Anaplan function, but can be built using a calculation.
ISNAChecks for #N/A error values.There is no native Anaplan function, but can be built using a calculation.
ISNONTEXTChecks for a value that is not text.There is no native Anaplan function, but can be built using a calculation.
ISNUMBERChecks for a numeric value.There is no native Anaplan function, but can be built using a calculation.
ISOWEEKNUMReturns the ISO week number for a date.There is no native Anaplan function. Use the internal time structure in Anaplan.
ISPMTReturns the interest payment for an investment.Use the RATE function to calculate a per period interest rate.
ISREFChecks for a reference.There is no native Anaplan function, but can be built using a calculation.
ISTEXTChecks for a text value.There is no native Anaplan function, but can be built using a calculation.

L

Excel functionExcel descriptionAnaplan solution
LARGEReturns the nth largest value from a set of values.There is no native Anaplan function, but can be built using a calculation.
LEFTExtract a substring from a string, starting from the leftmost character.Use the LEFT function.
LENReturns the length of the specified string.Use the LENGTH function to return the number of characters in a text string.
LINESTUses the least squares method to calculate the statistics for a straight line and returns an array describing that line.There is no native Anaplan function, but can be built using a calculation.
LNReturns the natural logarithm of a number.Use the LN formula to return the natural logarithm of a number, based on the constant e.
LOGReturns the logarithm of a number to a specified base.Use the LOG formula.
LOG10Returns the base-10 logarithm of a number.Use the LOG formula to return the logarithm of a number to the specified base.
LOOKUPReturns a value from a range (one row or one column) or from an array.Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item.
LOWERConverts all letters in the specified string to lowercase.Use the LOWER formula.

M

Excel functionExcel descriptionAnaplan solution
MATCHSearches for a value in an array and returns the relative position of that item.Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item.
MAXReturns the largest value from the numbers provided.Use the MAX function.
MAXAReturns the largest value from the values provided (numbers, text and logical values).Use the x[MAX_y] function.
MDETERMReturns the matrix determinant of an array.There is no native Anaplan function, but can be built using a calculation.
MDURATIONReturns the modified Macaulay duration for a security with an assumed par value of $100.Use the MDURATION formula.
MEDIANReturns the median of the numbers provided.There is no native Anaplan function, but can be built using a calculation.
MIDExtracts a substring from a string starting at any position.Use the MID formula to extract a substring from a string starting at any character.
MINReturns the smallest value from the numbers provided.Use the MIN formula to return the minimum of selected line items.
MINAReturns the smallest value from the values provided (numbers, text and logical values).Use the MIN formula to return the minimum of selected line items.
MINUTEReturns the minutes (a number from 0 to 59) from a time value.There is no native Anaplan function, but can be built using a calculation.
MINVERSEReturns the inverse matrix for a given matrix.There is no native Anaplan function, but can be built using a calculation.
MIRRReturns the modified internal rate of return for a series of cash flows.Use the IRR formula.
MMULTReturns the matrix product of two arrays.There is no native Anaplan function, but can be built using a calculation
MODReturns the remainder after a number is divided by a divisor.Modulus: remainder after dividing a dividend by a divisor.
MONTHReturns the month (a number from 1 to 12) given a date value.Use the MONTH formula to convert a date or a time period to a calendar month as a number.

N

Excel functionExcel descriptionAnaplan solution
NConverts a value to a number.Use the VALUE function.
NAReturns the #N/A error value.There is no native Anaplan function.
NETWORKDAYSReturns the number of work days between two dates, excluding weekends and holidays.There is no native Anaplan function, but can be built using a calculation.
NETWORKDAYS.INTLReturns the number of work days between two dates, excluding weekends and holidays.This is supported by the Anaplan settings.
NOTReturns the reversed logical value.Use operators and constants to create calculations and find the data you need.
NOWReturns the current system date and time.There is no native Anaplan function, but this can be built by creating a module called Today with one date formatted line item that is selected when required.
NPERReturns the number of periods for an investment.Use the NPER function.
NPVReturns the net present value of an investment.Use the NPV function.

O

Excel functionExcel descriptionAnaplan solution
ODDRounds a number up to the nearest odd integer.There is no native Anaplan function, this can be built using a ROUND calculation.
OFFSETReturns a reference to a range that is offset a number of rows and columns.There is no native Anaplan function, but can be built using a calculation.
ORReturns TRUE if any of the conditions are TRUEUse operators and constants with your data to create calculations and find the data you need.

P

Excel functionExcel descriptionAnaplan solution
PERCENTILEReturns the nth percentile from a set of values.There is no native Anaplan function, but can be built by using a calculation.
PERCENTRANKReturns the rank of a value in a set of values as a percentage of the set.

There is no native Anaplan function, but can be built by using a calculation.

Percentile = (number of values below X) + 0.5)/total number of values*100

PERMUTReturns the number of permutations for a specified number of items.

Use the POWER function for permutations where repetition is allowed, where:

  • x = the number of items
  • n = the number of permutations
PIReturns the mathematical constant called pi.There is no native Anaplan function, but can be built by using a calculation.
PMTReturns the payment amount for a loan.Use the PMT formula to take a date as a parameter and return a time period as a result.
POWERReturns the result of a number raised to a given power.Use the POWER function.
PPMTReturns the payment on the principal for a particular payment.See the Financial Functions.
PRICEReturns the price per $100 face value of a security that pays periodic interest.Use the PRICE function.
PRODUCTMultiplies the numbers and returns the product.Use an intermediate line item with the summary as the product.
PROPERSets the first character in each word to uppercase and the rest to lowercase.There is no native Anaplan function, but this can be achieved through a formula.
PVReturns the present value of an investment.Use the PV function to  calculate the present value of future cash flows.

Q

Excel functionExcel descriptionAnaplan solution
QUARTILEReturns the quartile from a set of values.There is no native Anaplan function, but can be built using a calculation.

R

Excel functionExcel descriptionAnaplan solution
RADIANSConverts degrees into radians.There is no native Anaplan function, but can be built using a calculation.
RANDReturns a random number that is greater than or equal to 0 and less than 1.There is no native Anaplan function, but can be built using a calculation.
RANDBETWEENReturns a random number that is between a bottom and top range.There is no native Anaplan function, but can be built using a calculation.
RANKReturns the rank of a number within a set of numbersUse the RANK function to  order a set of values, and assign rankings from 1 to a specified ending rank.
RATEReturns the interest rate for an annuity.Use the RATE function to calculate a per period interest rate.
REPLACEReplaces a sequence of characters in a string with another set of characters.Use the FIND, LEN, LEFT, RIGHT, or & function.
REPTReturns a repeated text value a specified number of times.There is no native Anaplan function, but can be built using a calculation.
RIGHTExtracts a substring from a string starting from the right-most character.Use the RIGHT function.
ROMANConverts a number to a roman numeral.There is no native Anaplan function, but can be built using a calculation.
ROUNDReturns a number rounded to a specified number of digits.Use the ROUND function.
ROUNDDOWNReturns a number rounded down to a specified number of digits.Use the ROUND function.
ROUNDUPReturns a number rounded up to a specified number of digitsUse the ROUND function.
ROWReturns the row number of a cell reference.Use the ITEM function.
ROWSReturns the number of rows in a cell reference.There is no native Anaplan function, but can be built using a calculation.

S

Excel functionExcel descriptionAnaplan solution
SEARCHReturns the location of a substring in a string.Use the FIND formula to look for a text string in a text formatted item, starting at a specified character number. The result is a number that denotes the character position.
SECONDReturns the seconds (a number from 0 to 59) from a time value.There is no native Anaplan function, but can be built using a calculation.
SIGNReturns the sign of a number.Use the SIGN function. The result is -1 if the value is negative, 1 if positive, or 0 if zero.
SINReturns the sine of an angle.There is no native Anaplan function, but can be built using a calculation.
SINHReturns the hyperbolic sine of a number.There is no native Anaplan function, but can be built using a calculation.
SLNReturns the depreciation of an asset based on the straight line depreciation method.Use the SPREAD function.
SLOPEReturns the slope of a regression line based on the data points identified by known_y_values and known_x_values.There is no native Anaplan function, but can be built using a calculation.
SMALLReturns the nth smallest value from a set of values.There is no native Anaplan function, but can be built using a calculation.
SQRTReturns the square root of a number.Use the SQRT function.
STDEVReturns the standard deviation of a population based on a sample of numbers.There is no native Anaplan function, but can be built using a calculation.
STDEVAReturns the standard deviation of a population based on a sample of numbers, text, and logical values.There is no native Anaplan function, but can be built using a calculation.
STDEVPReturns the standard deviation of a population based on an entire population of numbers.There is no native Anaplan function, but can be built using a calculation.
STDEVPAReturns the standard deviation of a population based on an entire population of numbers, text, and logical values.There is no native Anaplan function, but can be built using a calculation.
SUBSTITUTEReplaces a set of characters with another.Use the FINDLEN, or & function.
SUBTOTALReturns the subtotal of the numbers in a column in a list or database.Use the SUM & SELECT function to select an item from one or more of the hierarchy lists, and sum the values based on a list-formatted line item or property in the source that matches a dimension in the target.
SUMAdds all numbers in a range of cells.Use the SUM function to sum values based on a list formatted or time period formatted line item or property in the source that matches a dimension in the target.
SUMIFAdds all numbers in a range of cells based on one criteria.Create an intermediate module. Configure the rows as criteria, and columns as line items that SUM criteria.
SUMIFSAdds all numbers in a range of cells, based on a single or multiple criteria.Create an intermediate module. Configure the rows as criteria, and columns as line items that SUM criteria.
SUMPRODUCTMultiplies the corresponding items in the arrays and returns the sum of the results.There is no native Anaplan function, but can be built using a calculation.
SUMSQReturns the sum of the squares of a series of values.Use the POWER function with SUM.
SUMX2MY2Returns the sum of the difference of squares between two arrays.There is no native Anaplan function, but can be built using a calculation.
SUMX2PY2Returns the sum of the squares of corresponding items in the arrays.There is no native Anaplan function, but can be built using a calculation.
SUMXMY2Returns the sum of the squares of the differences between corresponding items in the arrays.There is no native Anaplan function, but can be built using a calculation.
SYDReturns the depreciation of an asset based on the sum-of-years digits depreciation method.There is no native Anaplan function, but can be built using a calculation.

T

Excel functionExcel descriptionAnaplan solution
TReturns the text referred to by a value.Use the TEXT function to convert a numeric value to text.
TANReturns the tangent of an angle.There is no native Anaplan function, but can be built using a calculation.
TANHReturns the hyperbolic tangent of a number.There is no native Anaplan function, but can be built using a calculation.
TEXTReturns a value converted to text with a specified format.Use the TEXT function to  convert a numeric value to text.
TEXTJOINUsed to join two or more strings together separated by a delimiter.Use the & function to concatenate two or more text strings.
TIMEReturns a decimal number given an hour, minute, and second value.There is no native Anaplan function, but can be built using a calculation.
TIMEVALUEReturns the serial number of a time.There is no native Anaplan function, but can be built using a calculation.
TODAYReturns the current system date.There is no native Anaplan function, but the date can be imported.
TRANSPOSEReturns a transposed range of cells.Create a module with a pivoted view.
TRIMReturns a text value with the leading and trailing spaces removed.Use the LENLEFT, or RIGHT formulas.
TRUEReturns a logical value of TRUE.Use a boolean argument.
TRUNCReturns a number truncated to a specified number of digits.Use the module formatting functionality.
TYPEReturns the type of a value.There is no native Anaplan function.

U

Excel functionExcel descriptionAnaplan solution
UPPERConvert text to all uppercase.Use the UPPER function.

V

Excel functionExcel descriptionAnaplan solution
VALUEConverts a text value that represents a number to a number.Use the VALUE formula to convert a numeric value in a text field to a number format.
VARReturns the variance of a population based on a sample of numbers.Use the SELECT and COLLECT formulas with line items to calculate the variance.
VARAReturns the variance of a population based on a sample of numbers, text, and logical values.Use the SELECT and COLLECT formulas with line items to calculate the variance.
VARPReturns the variance of a population based on an entire population of numbers.Use the SELECT and COLLECT formulas with line items to calculate the variance.
VARPAReturns the variance of a population based on an entire population of numbers, text, and logical values.Use the SELECT and COLLECT formulas with line items to calculate the variance.
VDBReturns the depreciation of an asset based on a variable declining balance depreciation method.See the Financial Functions.
VLOOKUPPerforms 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.Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a list formatted line item, a time period formatted item, or property from the source with a dimension of the target line item.

W

Excel functionExcel descriptionAnaplan solution
WEEKDAYReturns a number representing the day of the week, given a date value.Use the WEEKDAY formula to take a date and return a number from 1 to 7 for the day of the week. An optional Type parameter can be used to set the start day for the day of the week count.
WEEKNUMReturns the week number for a date.There is no native Anaplan function, but can be built using a calculation.
WORKDAYAdds a specified number of work days to a date, and returns the result as a serial date.There is no native Anaplan function, but can be built using a calculation.
WORKDAY.INTLAdds a specified number of work days to a date, and returns the result as a serial date (customizable weekends).There is no native Anaplan function, but can be built using a calculation.

X

Excel functionExcel descriptionAnaplan solution
XIRRReturns the internal rate of return for a series of cash flows that may not be periodic.See the Financial Functions.

Y

Excel functionExcel descriptionAnaplan solution
YEARReturns a four-digit year (a number from 1900 to 9999) given a date value.Use the YEAR function to convert a date or a time period to a year in a number format.
YEARFRACCalculates the fraction of the year represented by the number of whole days between two dates (the start date and the end date).Use the YEARFRAC function.
YIELDReturns the yield on a security that pays periodic interest.Use the YIELD function.