ExplanationReturns a Text value which is the formatted text version of the number specified.
The Text argument to the function specifies the format. Choose one of:
none_dot - returns the number formatted like 12345678.85
comma_dot - returns the number formatted like 12,345,678.85
comma_dot_2 - returns the number formatted like 1,23,45,678.85
none_comma - returns the number formatted like 12345678,85
dot_comma - returns the number formatted like 12.345.678,85
dot_comma_2 - returns the number formatted like 1.23.45.678,85
ExplanationReturns a Text value containing the formatted print representation of the number n, using the format f, with separators starting after number c digits. Valid values for c are 3 or 4; if it is 3, separators will be shown starting after 3 digits instead of after 4.
ExplanationReturns a Text value containing the print representation of the argument x. Includes a second argument indicating how many digits to include before truncating or rounding.
(Default) Legacy - up to 8 digits
Full - exposes the most digits possible
ExplanationReturns e raised to the nth power, where e is approximately 2.71828182845905
This exponential function is for use in logarithmic calculations that track growth. For example, you can use it to figure compounding interest.
ExamplesExp(2) returns 7.389056 (which is e, or 2.71828182845905, to the 2nd power)
ExplanationReturns the integer part of Number n.
Note that if n is a negative fraction, the result is closer to 0 than n is (compare to function Floor).
ExplanationReturns n modulo m. Mod implements 'clock' arithmetic; it models movement around a clock that is labeled with the numbers 0 to m-1. To get the result, just count n times around the clock. (Mod is the same as Rem for positive numbers, but different for negative numbers.)
You might use this function to auto-assign tasks to staff members. For details, please read this article
ExplanationReturns the name of the month whose number is n. Ensure n is a whole number between 1 and 12. Optionally enter 'short' in the second parameter to return the abbreviation of the month.
ExplanationCalculates the Present Value of a future payment. Rate is the discount rate for one time period. Nskip is the number of time periods before the payment occurs. Amt is the amount of the payment.
Arguments(Number rate, Number nskip, Number amt, Number npay)
Result TypeNumber
[+]more...
ExplanationCalculates the Present Value of a series of future payments. Rate is the discount rate for one time period. Nskip is the number of time periods before the first payment occurs. Amt is the amount of each payment. Npay is the number of payments in the series, spaced one time period apart.
ExplanationReturns a number that is the remainder after n is divided by d an integer number of times. (Mod is the same as Rem for positive numbers, but different for negative numbers.)
Arguments(Text textToPad, Number targetLength, Text paddingText)
Result TypeText
[+]more...
ExplanationExtends text to a target length by adding padding to the left of the text. If the text is already the target length or longer, then there's no change. Otherwise, the padding text is added as necessary to reach the target length. NOTE: This function pads up to a limit of 50 characters.
Arguments(Text textToPad, Number targetLength, Text paddingText)
Result TypeText
[+]more...
ExplanationExtends text to a target length by adding padding to the right of the text. If the text is already the target length or longer, then there's no change. Otherwise, the padding text is added as necessary to reach the target length. NOTE: This function pads up to a limit of 50 characters.
ExplanationReturns the specified part of a text value. The parts are separated by the occurrence of any delimiter character. The first argument, t, is the value to be searched. The second argument, p, is the position of the part in the argument t. The first part starting on the left is position 1. Negative part numbers can be used to start from the right. The third argument, d, is a text value containing all the possible delimiter characters.
If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter.
ExplanationReturns a Duration representing n days. This function takes a number and converts it into a Duration type value, expressed in days.
ExamplesDays(1.5) returns a 1.5 day duration
Days([Estimated # of days]) converts the numeric value in the Estimated # of days field into a duration expressed in days. The number doesn't change, just the data type.
ExplanationReturns a Duration representing n hours. This function takes a number and converts it into a Duration type value, expressed in hours.
ExamplesHours(4) returns a 4 hour duration
[Intake Time]+Hours(2) returns the time of day from the Intake Time field plus two hours.
Hours([Test Length in Hours]) converts the numeric value in the Test Length in Hours field into a duration expressed in hours. The number doesn't change, just the data type.
ExplanationReturns a Duration representing n minutes. This function takes a number and converts it into a Duration type value, expressed in minutes.
Examplesminutes(42) returns a duration of 42 minutes.
Minutes([Test Length in Minutes]) converts the numeric value in the Test Length in Minutes field into a duration expressed in minutes. The number doesn't change, just the data type.
[Start Time] + minutes(90) returns the time of day that 90 minutes after the time of day in the Start Time field.
ExplanationReturns a Duration representing n milliseconds. This function takes a number and converts it into a Duration type value, expressed in milliseconds.
ExamplesMseconds(250) returns a duration of 250 seconds.
Mseconds([Shutter Time]) converts the numeric value in the Shutter Time field into a duration expressed in milliseconds. The number doesn't change, just the data type.
ExplanationReturns a Duration that is the remainder after n is divided by d an integer number of times. (Mod is the same as Rem for positive numbers, but different for negative numbers.)
ExplanationReturns a Duration representing n seconds. This function takes a number and converts it into a Duration type value, expressed in seconds.
Examplesseconds(120) returns a duration of 120 seconds.
seconds([100yd Dash Finish Time]) converts the numeric value in the 100yd Dash Finish Time field into a duration expressed in seconds. The number doesn't change, just the data type.
[Start Time] + seconds(10) returns the time of day that's 10 seconds after the time of day in the Start Time field.
ExplanationReturns a Duration representing n weeks. This function takes a number and converts it into a Duration type value, expressed in weeks.
ExamplesWeeks(2) returns a 2 week duration
Weeks([Weeks until Delivery]) converts the numeric value in the Weeks until Delivery field into a duration expressed in weeks. The number doesn't change, just the data type.
ExplanationReturns the date which is m months after the given date d, with the same day number. If the day doesn't exist in that month, the last day of that month is returned.
ExamplesAdjustMonth([Ordered On], 3) returns the date three months after the date in the Ordered On field.
AdjustMonth(ToDate("2/20/99"), 2) returns April 20, 1999
AdjustMonth(ToDate("4/29/99"), -2) returns February 28, 1999
ExplanationReturns the date which is y years after the given date d, with the same month and day. If the day doesn't exist in that month, the last day of that month is returned.
ExamplesAdjustYear([Last Appt], 1) returns the date one year after the date in the Last Appt field.
AdjustYear([Date],-1) returns the date one year before the value in the Date field,
AdjustYear(ToDate("2/20/99"), 2) returns February 20, 2001
AdjustYear(ToDate("2/29/00"), -1) returns February 28, 1999
ExplanationReturns the number of days by which the given date d follows the first day of the week (Sunday returns 0).
ExamplesDayOfWeek([Start Date]) returns the number of the day of the week for the date that appears in the Start Date field.
DayOfWeek(ToDate("Aug 23, 2000")) returns 3
DayOfWeek(ToDate("Aug 20, 2000")) returns 0
ExplanationReturns the first day of the period in which the date d falls.
The cycle of periods is defined by the given Duration p, repeated in sequence starting at the given reference date r. If the period p is not a whole number of days, the fractional part is ignored.
ExamplesUseful for handling biweekly pay periods.
FirstDayOfPeriod([date field], Weeks(2), Date(2000,5,1)) returns the date that is the start of the two week period in which the date in the date field falls. The initial two week period that starts the cycle begins on May 1, 2000.