Functions or Equations (macros) supported by Windward
Overview
This article contains a full list of the functions (or equations) that Windward supports in MS Office.
Hint!
In general, if you want a value to print, use an Out Tag.
If you want to reference a value but not print it, try a Set Tag
You can use the Tag's formatting interface to choose the style for your output.
Equation Tools
The Equation Editor tool helps you use function and gives you previews of the results.
The Equation Selector tool helps you choose the best function to work with.
Date & Time:
FUNCTION 
DESCRIPTION 
Returns the date of the given year, month, and day. 

Can be added to a date to offset it. 

Returns serial number of given date using 1900 date system. 

DAY 
Returns the numeric day of the month, for the given year, month and day. 
Returns the number of days between two given dates. 

HOUR 
Returns the hour of the given time (hour, minute, and second). 
MINUTE 
Returns the minutes of the given time (hour, minute, and second). 
MONTH 
Returns the month of the given year, month and day. 
NOW 
Returns the current date and time formatted as a date and time. 
SECOND 
Returns the seconds of the given time (hour, minute and second). 
Returns the time of the given hour, minute, and second. 

Can be added to a time to offset it 

TIMEVALUE 
Returns the decimal number of the time. 
TODAY 
Returns the current date. 
WEEKDAY 
Returns a Variant (Integer) containing a whole number representing the day of the week. 
WEEKNUM 
Returns the week number of a specific date. 
WORKD.INTL 
Returns the date after a specified number of workdays with custom weekend parameters. 
WORKDAY 
Returns the date after a specified number of workdays with custom weekend parameters. 
YEAR 
Returns the year of the given year, month and day. 
YEARFRAC 
Returns the fraction of the year represented by the number of whole days between two dates. 
Math & Trig:
FUNCTION 
DESCRIPTION 
ABS 
Returns the absolute value of a number; a number without a sign. 
Converts a number into text representation with given radix. 

BASE64DECODE 
Decodes base 64 encoded image. 
Returns a number rounded up to the nearest integer or to the nearest multiple of significance. 

Returns a text representation of a number in given base into decimal number. 

Returns degrees of radian angle. 

Returns number rounded up to the nearest even integer. 

Returns a factorial of a number 

Returns a number rounded down to the nearest integer or to the nearest multiple of significance. 

Returns True if number is Even, and False if Odd. 

Returns True if number is Odd and False if Even. 

Returns number rounded up to the nearest odd integer. 

Returns the result of a number raised to a power. 

Returns the integer portion of a division (no remainder or decimal values). 

Returns an evenly distributed random real number from 0 to 1. 

Returns a random integer number between any given two numbers. 

Returns number rounded to specific number of digits. 

Returns the secant of an angle. 

STANDARDIZE 
Returns a normalized value from a distribution characterized by mean and standard_dev. 
STDEV 
Returns the standard deviation of a group of numbers. 
STDEVA 
Returns the standard deviation of group of numbers. 
STDEVP 
Calculates standard deviation of group of numbers based on the entire population. 
STDEVPA 
Calculates the standard deviation of a group of numbers based on the entire population. 
STDEVS 
Calculates standard deviation of group of numbers based on the entire population. 
SUM 
Adds all the numbers in a range of values. 
Multiplies corresponding components in given ranges and returns the sum of those products. 
Statistical:
FUNCTION 
DESCRIPTION 
ADDTOTAL 
Add number of running total. 
Returns the average of absolute deviations of data points from their mean. 

Returns the average (arithmetic mean) of its arguments, which can be numbers of names, arrays, or reference that contain numbers. 

Counts the number of values in a range that contains numbers. 

Calculates how often values occur within range of values. 

GETTOTAL 
Get number of running total. 
Returns the largest value in a set of values. Ignores logical values and text. 

Returns the median of given numbers. 

Returns the smallest value in a set of values. Ignores logical values and text. 

Returns the kth percentile of values in a range, where k is in range the from 0 to 1 exclusive. 

Returns the kth percentile of values in a range, where k is in range the from 0 to 1 inclusive. 

PERCENTILERANK.EXC 
Returns the rank of a value in a data set as a percentage (0...1, exclusive) of the data set. 
Returns the rank of a value in dataset as a percentage from 0 to 1 inclusive. 

PRODUCT 
Returns the multiplication of all numbers given as arguments, which can be numbers of names, arrays, or references that contain numbers. 
Database:
FUNCTION 
DESCRIPTION 
Returns a dataset using the text. 

Returns a date type dataset using the text, using input as the date format. 

Returns a null value. Primarily used to compare against the value of DATA. 
Text:
FUNCTION 
DESCRIPTION 
CHAR 
Returns the character specified by a number. 
CONCATENATE 
Joins two or more text strings into one string. 
Returns whether one text string contains another text string. 

Returns the first index of one text string within another text string. 

Returns the last index of one text string within another text string. 

Returns characters from the left of text string, given a length. 

Returns the length of the text. 

Returns the text with all letters in lowercase. 

MID 
Returns the characters from the middle of a text string, given a starting position and length. 
Converts text to number, in a localeindependent way. 

Capitalizes the first letter in text string and any other letters in that text that follow any character other than a letter. 

Extract matching substrings according to regular expressions. 

Whether a piece of text matches a regular expression. 

Replaces part of text string with different text string using regular expression. 

Replace each substring of text with given replacement. 

Returns characters from the right of text string, given a length. 

Returns the index of first occurrence of given character or string. 

Replace each substring of text string with replacement. 

Returns the characters from the middle of a text string, given a starting position and an ending position. 

TEXT  Converts a numeric or date value to Text, and lets you specify the display formatting by using special format strings. 
TRIM 
Returns the text with the whitespace removed from the beginning and the end. 
Returns the text with all letters in uppercase. 

URLDECODE 
Decodes the URL according to PFC2396. Returns the decoded URL. 
URLENCODE 
Encodes the URL according to PFC2396. Returns the encoded URL. 
VALUE 
Converts a text string into a number. 
Logical:
FUNCTION 
DESCRIPTION 
Returns the logical value FALSE. 

IF 
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. 
Return True if input value is number and False otherwise. 

TRUE 
Returns the logical value TRUE. 
Custom:
FUNCTION 
DESCRIPTION 
MULTIPLYALL 
Returns a value equal to all the values of a dataset multiplied together. 
PI 
Returns the value of Pi, 3.14159265358979, accurate to 15 digits. 
Returns an array of objects. 

SETMACROSTATE 
(deprecated) 
Returns a positive square root. 