Skip to main content
Windward

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​

DATE​

​Returns the date of the given year, month, and day.

DATESPAN

​Can be added to a date to offset it.

DATEVALUE

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.

DAYS

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).

​TIME

​Returns the time of the given hour, minute, and second.

TIMESPAN

​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.

Return to Top

Math & Trig:

​FUNCTION

DESCRIPTION​

ABS

​Returns the absolute value of a number; a number without a sign.

BASE

Converts a number into text representation with given radix.

BASE64DECODE

Decodes base 64 encoded image.

CEILING

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

DECIMAL

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

DEGREES

Returns degrees of radian angle.

EVEN

Returns number rounded up to the nearest even integer.

FACT

Returns a factorial of a number

FLOOR

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

ISEVEN

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

ISODD

Returns True if number is Odd and False if Even.

ODD

Returns number rounded up to the nearest odd integer.

POWER

Returns the result of a number raised to a power.​

QUOTIENT

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

RAND

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

RANDBETWEEN

Returns a random integer number between any given two numbers.

ROUND

Returns number rounded to specific number of digits.

SEC

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.

SUMPRODUCT

Multiplies corresponding components in given ranges and returns the sum of those products.

Return to Top

Statistical:

​​FUNCTION

DESCRIPTION​

ADDTOTAL

Add number of running total.

AVEDEV

Returns the average of absolute deviations of data points from their mean.

AVERAGE

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

COUNT

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

FREQUENCY

Calculates how often values occur within range of values.

GETTOTAL

Get number of running total.

MAX

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

MEDIAN

Returns the median of given numbers.

MIN

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

PERCENTILE.EXC

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

PERCENTILE.INC

Returns the k-th 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.

PERCENTILERANK.INC

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.

Return to Top

 

Database:

​FUNCTION

DESCRIPTION​​

​DATA

​Returns a dataset using the text.

DATEDATA​

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

NULL

​Returns a null value. Primarily used to compare against the value of DATA.

Return to Top

Text:

​FUNCTION

DESCRIPTION​

CHAR

Returns the character specified by a number.

CONCATENATE

Joins two or more text strings into one string.

CONTAINS

​Returns whether one text string contains another text string.

INDEXOF

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

​LASTINDEXOF

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

LEFT

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

LEN

Returns the length of the text.

LOWER

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.​

NUMBERVALUE

Converts text to number, in a locale-independent way.

PROPER

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

REGEXEXTRACT

Extract matching substrings according to regular expressions.

REGEXMATCH

Whether a piece of text matches a regular expression.

REGEXREPLACE

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

REPLACE

Replace each substring of text with given replacement. 

RIGHT

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

SEARCH

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

SUBSTITUTE

Replace each substring of text string with replacement.

SUBSTRING

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.

UPPER

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.

Return to Top

Logical:

​​FUNCTION

DESCRIPTION​

FALSE​

​Returns the logical value FALSE.

IF

​Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.

ISNUMBER

Return True if input value is number and False otherwise.

TRUE

​Returns the logical value TRUE.

Return to Top

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.

RANGE

Returns an array of objects.

SETMACROSTATE

(deprecated)

SQRT

Returns a positive square root.

Return to Top