Formulas

Formulas allow you to customize pricing logic in CoreBridge exactly as you need it. They’re really easy to use - and if you know Excel formulas, then you already know CoreBridge formulas!

Writing Formulas

You can use formulas anywhere you see the following icon:Simply type = to start writing your formula.

Basic Math

You can use all the math features you’d expect: 

10 + 10  Result = 20 
10 - 5  Result = 5 
10 / 2  Result = 5 
10 * 5  Result = 50 

Comparisons

You can compare two values (or formulas). Comparisons always return boolean values.  Comparisons can be really useful when using conditions (e.g. the "IF" function): 

10 > 5  Result = TRUE 
10 == 9  Result = FALSE

You can also combine comparisons using the "AND" and "OR" functions (see function definitions for more details):

=AND(10 > 5, 6 > 3)  Result = TRUE
=OR(5 < 1, 10 >= 8)  Result = TRUE
=OR(1 > 3, 10 < 5)  Result = FALSE

Using Functions

Functions can be called by typing the equal sign "=", then writing the name of the function you want to use, followed by an open parenthesis "(".  Most of the functions you already know from Excel work the same way in CoreBridge.

=Lower("HELLO")  Result = hello
=Sum(10, 20, 30)  Result = 60

Functions 

Date & Time

Date

Date(year, month, day)

Provides the date as a date serial number.

EXAMPLE:

Date(2020, 01, 01)  Result = 43831
Date(2019, 4, 24)  Result =  43579

INPUTS

RETURNS 

number    Returns the date as a date serial number given a year, month, day.

DateDif

DateDif(start_date, end_date, unit)

Calculates the difference between two dates and returns the result in the units specified (days, months, years).  

EXAMPLE:

DateDif("01 Jan 2020", "04 Jan 2020", "D")  Result = 3
DateDif("01 Jan 2019", "01 Jan 2020", "M")  Result = 12  
DateDif("02 Jan 2018", "02 Jan 2020", "Y")  Result = 2

INPUTS

RETURNS 

number    Returns number of units between two dates.

DateValue

DateValue(date_text)

This function converts a date that is stored as text to a serial number that is recognizes as date.

EXAMPLE:

DateValue("22 August 2020")  Result = 44065
DateValue("5/22/2011")  Result = 40685
DaeValue("1-Jul")  Result = 44013

INPUTS

RETURNS 

number    Returns the date serial number given a date in text format.

Day

Day(serial_number)

Provides the date that contains the day you want to find.

EXAMPLE:

Day("01 July 2020")  Result = 1
Day("30 Apr 2019")  Result = 30

INPUTS

RETURNS 

number    Returns the day as an integer given a date serial number.

Days

Days(end_date, start_date)

Calculates the number of days between specified dates.

EXAMPLE:

Days("01 July 2020", "15 Jun 2020)  Result = 16
Day("30 Apr 2019", "15 Apr 2019")  Result = 15

INPUTS

RETURNS 

number    Returns the number of days between two dates.

EOMonth

EOMonth(start_date, months)

Calculates the serial number of the last day of a month before or after a specified date.

EXAMPLE:

EOMonth("01/07/1977", 0)  Result = 28156
EOMonth("01/01/2020", -24)  Result = 43131

INPUTS

RETURNS 

number    Returns the serial number of the last day of the month before or after a date.

Hour

Hour(serial_number)

Calculates the hour as a time value. The hour is given as an integer in the range 0 (zero) to 23.

EXAMPLE:

Hour(0.678)  Result = 16
Hour("11:30:15")  Result = 11

INPUTS

RETURNS 

number    Returns the hour as an integer given a time serial number.

Minute

Minute(serial_number)

Calculates the minutes as a time value. The second is given as an integer in the range 0 (zero) to 59

EXAMPLE:

Minute(0.678)  Result = 16
Minute("11:30:15")  Result = 30

INPUTS

RETURNS 

number   Returns the minutes as an integer given a time serial number.

Month

Month(serial_number)

Provides the month that you want to find.

EXAMPLE:

Month("01 Jul 2003")  Result = 7
Month(37803)  Result = 7

INPUTS

RETURNS 

month    Returns the month as an integer given a date serial number.

Now

Now()

Calculates the current date and time.  Does not require any arguments.

EXAMPLE:

Now()  Result = current date and time

INPUTS

RETURNS 

number   Returns the serial number of the current system date and time.

Second

Second(serial_number)

Calculates the seconds as a time value. The second is given as an integer in the range 0 (zero) to 59.

EXAMPLE:

Second(0.678)  Result = 19
Second("11:30:15")  Result = 15

INPUTS

RETURNS 

number    Returns the number of seconds as a integer given a time serial number.

Time

Time(hour, minute, second)

Provides a time as a decimal given an hour, minute, second.

EXAMPLE:

Time(12, 0, 0)  Result = 12:00:00 PM
Time(23, 20, 36)  Result = 11:20:36 PM

INPUTS

RETURNS 

number    Returns the time as a decimal given an hour, minute ,second.

TimeValue

TimeValue(time_text)

Provides the time as a decimal given a time in text format.

EXAMPLE:

TimeValue("6:00 PM")  Result = 0.750
TimeValue("12:00:00")  Result = 0.5  

INPUTS

RETURNS 

number    Returns the time as a decimal given a time in text format.

Today

Today()

Calculates the current date and does not require any arguments.

EXAMPLE:

Today()  Result = current date

INPUTS

RETURNS 

number    Returns to serial number representing today's date.

Weekday

Weekday(serial_number [,return_type])

Provides the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday) by default.

EXAMPLE:

Weekday(24194)  Result = 2 (Monday)
Weekday("28 Mar 1999")  Result = 1 (Sunday)

INPUTS

RETURNS 

number    Returns the day of the week for a given date.

WeekNum

WeekNum(serial_num [,return_type])

Provides the week number of a specific date. For example, the week containing January 1 is the first week of the year, and is numbered 1.

EXAMPLE:

WeekNum(36434)  Result = 40
WeekNum("10/01/1999")  Result = 40

INPUTS

RETURNS 

number    Returns the week number between 1 and 54 in the year for a given date.

Year

Year(serial_number)

Provides a year component of a date as a 4 digit number. 

EXAMPLE:

Year(38093)  Result = 2004
Year("01 Jul 2003")  Result = 2003

INPUTS

RETURNS 

number    Returns the year as an integer given a date serial number.

Information

IsBlank

IsBlank(value)

Checks whether the value is blank, and returns a TRUE or FALSE.

EXAMPLE:

IsBlank("some text")  Result = FALSE
IsBlank(12)  Result = FALSE

INPUTS

RETURNS 

TRUE  or  FALSE    If the value is blank it will return TRUE, if it isn't blank it will return FALSE.

IsEven

IsEven(number)

Checks whether the value is even, returns TRUE if the number is even.  If number is not an integer it is truncated.

EXAMPLE:

IsEven(14)  Result = TRUE
IsEven(12.5)  Result = TRUE
IsEven(23)  Result = FALSE

INPUTS

RETURNS 

TRUE  or  FALSE    If the number is even it will return TRUE; anything else will return FALSE.

IsNonText

IsNonText(value)

Checks whether the value is non text, and returns a TRUE or FALSE

EXAMPLE:

IsNonText("some text")  Result = FALSE
IsNonText(10)  Result = TRUE

INPUTS

RETURNS 

TRUE  or  FALSE    If the value is non text it will return TRUE, otherwise it will return FALSE.

IsNumber

IsNumber(value)

Checks whether the value is a number, and returns a TRUE or FALSE.

EXAMPLE:

IsNumber("some text")  Result = FALSE
IsNumber(10)  Result = TRUE
IsNumber(-5.3)  Result = TRUE

INPUTS

RETURNS 

TRUE  or  FALSE    If the value is a number it will return TRUE, if not it will return FALSE.

IsOdd

IsOdd(number)

Checks whether the value is odd, returns TRUE if the number is odd.  If number is not an integer it is truncated.

EXAMPLE:

IsOdd(13)  Result = TRUE
IsOdd(7.6)  Result = TRUE
IsOdd(16)  Result = FALSE

INPUTS

RETURNS 

TRUE  or  FALSE    If the number is odd it will return TRUE, anything else will return FALSE.

IsText

IsText(value)

Checks whether the value is text, and returns a TRUE or FALSE.

EXAMPLE:

IsText("some text")  Result = TRUE
IsText(10)  Result = FALSE

INPUTS

RETURNS 

TRUE  or  FALSE    If the value is text it will return TRUE, if not it will return FALSE.

Logical

And

And(condition01, condition02,...)

Checks whether all conditions are TRUE and returns TRUE if all conditions are TRUE.

EXAMPLE:

AND(1 < 2, 5 > 3, 2 = (1+1))  Result = TRUE
AND(10 < 5, 10 < 20)  Result = FALSE

INPUTS

RETURNS 

TRUE  or  FALSE    Depending on the result of the conditions check, returns TRUE if all results are TRUE or FALSE if at least one condition is FALSE.

If

If(logical_test, value_if_true, value_if_false)

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

EXAMPLE:

IF(1 > 2, "I am amazing", "I am not")  Result = "I am not"
IF(AND(3 < 5, 6 > 4), TRUE, FALSE)  Result = TRUE

INPUTS

RETURNS 

any    Depending on the result of the logical_test, returns value_if_true when TRUE or value_if_false when FALSE.

Not

not(logical)

Returns the opposite of the logical evaluation.  Changes FALSE to TRUE and TRUE to FALSE.  Use the NOT function to reverse a logical value.

EXAMPLE:

NOT(FALSE)  Result = TRUE
NOT1 + 1 = 2)  Result = FALSE
NOT(5 > 10)  Result = TRUE
IF(NOT(FALSE),"True", "False")  Result = True

INPUTS

RETURNS 

TRUE  or  FALSE    Depending on the result of the logical check, when TRUE, returns FALSE and when FALSE, returns TRUE.

Or

Or(condition01, condition02,...)

Checks whether any of the conditions are TRUE and returns TRUE or FALSE.  Returns FALSE only if all conditions are FALSE.

EXAMPLE:

OR(1 < 2, 5 > 3, 2 = (1+4))  Result = TRUE
OR(1 + 1 = 1, 2 + 2 = 5)  Result = FALSE

INPUTS

RETURNS 

TRUE  or  FALSE    Depending on the result of the conditions check, returns TRUE if any of the results are TRUE or FALSE if all conditions are FALSE.

Math

ABS

ABS(number)

Determines the absolute value of a number. Also called its modulus, the absolute value of the number is just the number without its sign. The "number" can be a cell reference or a named range. If the "number" is negative, it simply removes the sign, returning a positive number.

EXAMPLE:

ABS(2)  Result = 2
ABS(-4)  Result = 4
ABS(5 - 10)  Result = 5

INPUTS

RETURNS 

number      Returns the absolute value of a number without its sign.

Average

Average(number1, number2,...)

Returns the average (arithmetic mean) of its arguments.  The arithmetic mean is the most common measure of central tendency.

EXAMPLE:

AVERAGE(2, 4)  Result = 3
AVERAGE(2, 3, 4, 5, 6)  Result = 4

INPUTS

RETURNS 

number     Returns the average of all the included arguments.

COS

COS(number)

Calculates the Cosine of a number.  This function is periodic with a period of 2PI.  The "number" is the angle in radians.  

EXAMPLE:

COS(0)  Result = 1.0
COS(1)  Result = 0.54

INPUTS

RETURNS 

number    Returns the cosine of the number specified.

COT

COT(number)

Calculates the Cotangent of a given number.  The "number" is the angle in radians.  

EXAMPLE:

COT(-PI() / 4)  Result = -1.000

INPUTS

RETURNS 

number    Returns the cotangent of the number specified.

Even

Even(number)

Calculates the number rounded up to the nearest even integer. Negative numbers will be round down. 

EXAMPLE:

EVEN(23.4)  Result = 24
EVEN(-23.4)  Result = -24

INPUTS

RETURNS 

number      Returns the rounded number up to the nearest even integer.

EXP

EXP(number)

Calculates the exponential number raised to a particular power.

EXAMPLE:

EXP(1)  Result = 2.7183
EXP(2)  Result = 7.3891
EXP(-1) Result = 0.3679

INPUTS

RETURNS 

number        Returns the exponential number raised to a particular power.

INT

INT(number)

Calculates the number rounded down to the nearest integer.

EXAMPLE:

INT(1.5)  Result = 1
INT(-1.5)  Result = -1

INPUTS

RETURNS 

number    Returns the number rounded down to the next integer.

LN

LN(Number)

Calculates the natural logarithm of a number.  Natural logarithms are based on the constant e (2.71828182845905).

EXAMPLE:

LN(1)  Result = 0.00
LN(2)  Result = .69
LN(3)  Result = 1.10

INPUTS

RETURNS 

number    Returns the natural logarithm of the input number.

LOG

Log(number [,base])

Calculates the logarithm of a number to its base.  If "base" is left blank then 10 is used. 

EXAMPLE:

LOG(12)  Result = 1.08
LOG(10)  Result = 1
LOG(8, 2)  Result = 3

INPUTS

RETURNS 

number    Returns the logarithm of a number to any base.

LOG10

Log(number)

Calculates the logarithm of a number to the base 10. 

EXAMPLE:

LOG10(86)  Result = 1.934
LOG10(10)  Result = 1
LOG10(10 * 10)  Result = 2

INPUTS

RETURNS 

number    Returns the logarithm of a number to the base 10.

MAX

MAX(Number1,Number2, ....)

Shows the largest value in a list of values.

EXAMPLE:

MAX(5, 2, 6, 9)  Result = 9
MAX(2, 4, 6, 8)  Result = 8
MAX({5, 4, 3, 2, 1})  Result = 5

INPUTS

RETURNS 

number   The highest value in the listed values.

Median

Median(number1, number2,...)

The median is the middle of the distribution after the numbers have been sorted into ascending order.  If there is an odd number of unique numbers in the set, then the number in the middle is returned.  If there is an even number of unique numbers in the set, then the average of the two numbers in the middle is calculated.

EXAMPLE:

MEDIAN(1, 2, 3)  Result = 2
MEDIAN(1, 2, 3, 4)  Result = 2.5
MEDIAN(1, 2, 3, 4, 0)  Result = 2

INPUTS

RETURNS 

number     Returns the median value in a list of numbers after being sorted into ascending order.  

MIN

MIN(number1, number2, ....)

Shows the smallest value in a list of values.

EXAMPLE:

MIN(5, 2, 6, 9)  Result = 2
MIN(2, 4, 6, 8)  Result = 2
MIN(2, "4", "6", 8)  Result = 2
MIN({5, 4, 3, 2, 1})  Result = 1

INPUTS

RETURNS 

number   The smallest value in the listed values.

MOD

Mod(number, divisor)

The result of this function is the remainder when "number" is divided by "divisor".  The result will have the same sign as the sign of the "divisor".

EXAMPLE:

MOD(3, 2)  Result = 1
MOD(-3, 2)  Result = 1
MOD(3, -2)  Result = -1
MOD(-3, -2)  Result = -1
MOD(2, 3)  Result = 2

INPUTS

RETURNS 

number     Returns the remainder after division.

MRound

MRound(number, multiple)

Returns the number rounded to the desired multiple.

EXAMPLE:

MROUND(10,3)  Result = 9
MROUND(-10,-3)  Result = -9
MROUND(1.58,0.5)  Result = 1.5
MROUND(1.3,0.2)  Result = 1.4

INPUTS

RETURNS 

number   Number rounded to the listed multiple.

ODD

ODD(number)

Calculates the number rounded up to the nearest odd integer.  If "number" < 0, then the number is rounded down (away from zero).  If "number" is an odd number then no rounding takes place.

EXAMPLE:

ODD(13)  Result = 13
ODD(-8)  Result = -9
ODD(20)  Result = 21
ODD(0)  Result = 1
ODD(-1)  Result = -1

INPUTS

RETURNS 

number     Returns the number rounded to the nearest odd integer.

PI

PI()

This simply returns the number PI.  This constant is used to calculate the area of a circle.  This is one of the few functions that does not require any arguments.

EXAMPLE:

PI()  Result = 3.141592654

INPUTS

RETURNS 

number     Returns the number PI.

Power

Power(number, power)

Calculates the number raised to a given power. The "^" operator can be used instead of this function to indicate to what power the base number is to be raised, such as in 5^2.

EXAMPLE:

POWER(2, 2)  Result = 4
POWER(5, 2)  Result = 25
POWER(98.6, 3.2)  Result = 2401077

INPUTS

RETURNS 

number    Returns the number raised to a given power.

Round

Round(number, num_digits)

Rounds the number to a specified number of digits.  Any digits less than 5 are rounded down.  Any digits greater than or equal to 5 are rounded up.  This function operates on the actual value in the cell and rounds them so they are consistent with the value that is displayed.

EXAMPLE:

ROUND(123.456, -4)  Result = 0
ROUND(123.456, -3)  Result = 0
ROUND(123.456, -2)  Result = 100
ROUND(123.456, -1)  Result = 120
ROUND(123.456, 0)  Result = 123
ROUND(123.456, 1)  Result = 123.5
ROUND(123.456, 2)  Result = 123.46
ROUND(123.456, 3)  Result = 123.456

INPUTS

RETURNS 

number      Returns the number rounded to a specified number of digits.

RoundDown

RoundDown(number, num_digits)

Rounds the number down to the specified number of digits.  This function is identical to the ROUND function except it always rounds a number down.

EXAMPLE:

ROUNDDOWN(123.456, -4)  Result = 0
ROUNDDOWN(123.456, -3)  Result = 0
ROUNDDOWN(123.456, -2)  Result = 100
ROUNDDOWN(123.456, -1)  Result = 120
ROUNDDOWN(123.456, 0)  Result = 123
ROUNDDOWN(123.456, 1)  Result = 123.4
ROUNDDOWN(123.456, 2)  Result = 123.45
ROUNDDOWN(123.456, 3)  Result = 123.456

INPUTS

RETURNS 

number     Returns the number rounded down to the specified number of digits.

RoundUp

RoundUp(number, num_digits)

Rounds the number up to the specified number of digits.  This function is identical to the ROUND function except it always rounds a number up.

EXAMPLE:

ROUNDUP(123.456, -4)  Result = 10000
ROUNDUP(123.456, -3)  Result = 1000
ROUNDUP(123.456, -2)  Result = 200
ROUNDUP(123.456, -1)  Result = 130
ROUNDUP(123.456, 0)  Result = 124
ROUNDUP(123.456, 1)  Result = 123.5
ROUNDUP(123.456, 2)  Result = 123.46
ROUNDUP(123.456, 3)  Result = 123.456

INPUTS

RETURNS 

number     Returns the number rounded up to the specified number of digits.

SIN

SIN(number)

This calculates the sine of a number.  The "number" is the angle in radians.

EXAMPLE:

SIN(0)   Result = 0.000
SIN(0.5)  Result = 0.479
SIN(1)  Result = 0.841

INPUTS

RETURNS 

number     Returns the sine of a number.

SQRT

SQRT(number)

This will return the square root of a number.  You can calculate the square root of a number by raising it the power of one half, for example "16^0.5 = 4".

EXAMPLE:

SQRT(16)  Result = 4
SQRT(4*4)  Result = 4
SQRT(25)  Result = 5
SQRT(100)  Result = 10

INPUTS

RETURNS 

number     Returns the positive square root of a number.

SUM

SUM(number1, number2,....)

Calculates the total value of the numbers provided.

EXAMPLE:

SUM(10, 20, 30)  Result = 60
SUM(3, 2, -1)  Result = 4

INPUTS

RETURNS 

number      Returns the total value of the numbers provided.

TAN

TAN(number)

Calculates the tangent of a number.  The "number" is the angle in radians.

EXAMPLE:

TAN(0)  Result = 0.000
TAN(0.5)  Result = 0.546
TAN(1)  Result = 1.557

INPUTS

RETURNS 

number       Returns the tangent of the input number.

TRUNC

TRUNC(number [,num_digits])

Truncates the given number to remove any decimal places.  

EXAMPLE:

TRUNC(18.978)  Result = 18
TRUNC(12.345, 1)  Result = 12.3
TRUNC(8.9)  Result = 8

INPUTS

RETURNS 

number   Returns the number with any decimal places removed.

Text

CHAR

CHAR(number)

This determines the character with the corresponding ANSI/ASCII number. This function is useful when you want to specify characters that are difficult or impossible to type directly.

EXAMPLE:

CHAR(65)  Result = A
CHAR(66)  Result = B
CHAR(67)  Result = C
CHAR(97)  Result = a

INPUTS

RETURNS 

number    This returns the character corresponding to the ANSI/ASCII.

Clean

Clean(Text)

This function removes any non-printable characters including tabs and program-specific codes. It is also useful when you want to remove characters that will not be printed.

EXAMPLE:

CLEAN(CHAR(7) & "text" & CHAR(7))  Result = text
CLEAN(" some text" & CHAR(7) & "some more ")  Result = some textsome more
CLEAN(20)  Result = 20

INPUTS

RETURNS 

text    Returns the text string with all the non-printable characters removed.

Concatenate 

Concatenate(text1 [,text2] [..])

Returns the text string that is a concatenation of several strings. This function is equivalent to the "&" character.

EXAMPLE:

CONCATENATE("the start", " and the end")  Result  = the start and the end
CONCATENATE("ab", "cd", "ef", "gh")  Result = abcdefgh
CONCATENATE(1, 2, 3, 4)  Result = 1234

INPUTS

RETURNS 

text    This will return the merged text field.

Dollar

Dollar(number [,decimals])

This formats the text string of a number with the dollar formatting $0,000.00. The currency symbol that it applies depends on your language settings. If your language is English (United Kingdom) the symbol used is £

EXAMPLE:

DOLLAR(100)   Result = $100.00
DOLLAR(1234.567, 2)  Result  = $1,234.57
DOLLAR(1234.567, -2)  Result = $1,200.00
DOLLAR(-1234.567, 2)  Result = -$1,234.57

INPUTS

RETURNS 

number    Returns the text string of the number formatted as dollars.

Exact

Exact(text1, text2)

This function checks if the value is True or False based on whether two strings match exactly. This function is case sensitive. 

EXAMPLE:

EXACT("word", "word")  Result = True
EXACT("wOrd", "word")  Result = False
EXACT("WORD", "word")  Result = False
EXACT("word", "word ")  Result = False

INPUTS

RETURNS 

text    This will return True or False.

Find

Find(find_text, within_text [,start_num])

This returns the starting position of a substring within a larger text string. This works similarly to a case sensitive search function. 

EXAMPLE:

FIND("M", "Miriam McGovern")  Result = 1
FIND("m", "Miriam McGovern")  Result = 6
FIND("m", "Miriam McGovern", 1)  Result = 6

INPUTS

RETURNS 

number    The position of the substring in the larger text string. 

Fixed

Fixed(number [,decimals] [,no_commas])

This function returns the text string of a number rounded to a fixed number of decimal places. This actually returns the text from an input number. 

EXAMPLE:

FIXED(1234.567,1)  Result = 1234.6
FIXED(1234.567,-1)  Result = 1230
FIXED(-1234.567,-1)  Result = -1230

INPUTS

RETURNS 

text     The number rounded to a fixed number of decimal places as text.

Left

Left(text [,num_chars])

This function returns the first or left most characters in a text string. If "text" is a text string then it must be enclosed in speech marks.

EXAMPLE:

LEFT("Better Solutions", 6)  Result = Better
LEFT("Better", 1)  Result = B
LEFT("Better", 0)  Result = blank

INPUTS

RETURNS 

text    This returns the leftmost character in a text string.

Len

LEN(text)

This function will count how many characters there are in a text string. Any blank spaces are counted as individual characters.

EXAMPLE:

LEN("some text")  Result = 9
LEN(" some text")  Result = 10
LEN("")  Result = 0

INPUTS

RETURNS 

number    This returns the total length of the string. 

Lower

Lower(text)

Converts all letters in a text string to lowercase.  This function will not change characters in text that are not letters.

EXAMPLE:

Lower("SOME TEXT")  Result = some text
Lower("1A2B3C4D")  Result = 1a2b3c4d

INPUTS

RETURNS 

text    Returns the text string with all the characters converted to lowercase.

Mid

Mid(text, start_num, num_chars)

Provides a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.

EXAMPLE:

Mid("this is some text", 9,4)  Result = some
Mid("this is some text", 1,2)  Result = th

INPUTS

RETURNS 

text    Returns the text string which is a substring of a given string.

NumberValue 

NumberValue(text [,decimal_separator] [,group_separator])

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

EXAMPLE:

NumberValue("3.5%")  Result = 0.035
NumberValue("2^500.27", ".", "^")  Result = 2500.27

INPUTS

RETURNS 

number    Returns the number that a string represents ( current locale).

Proper

Proper(text)

Converts the first letter of every word to a capital letter.  Letters following a number, punctuation character or do not follow another letter will be capitalized. Letters that follow another letter will be converted to lowercase.

EXAMPLE:

Proper("some TEXT")  Result = Some Text
Proper("1a2b3c4d")  Result = 1A2B3C4D

INPUTS

RETURNS 

text    Returns the text string with the first letter of every word as a capital letter.

Replace

Replace(old_text, start_num, num_chars, new_text)

Replaces part of a text string, based on the number of characters you specify, with different text string. This function uses the position to replace characters.

EXAMPLE:

Replace("Better Solutions", 1, 6, "Awesome")  Result = Awesome Solution
Replace("2 March,2020", 1, 1, "1")  Result = 1 March, 2020

INPUTS

RETURNS 

text    Returns the text string after replacing characters in a specific location.

Right

Right(text [,num_chars])

Provides the last character or characters in a text string, based on the number of characters you specify.

EXAMPLE:

Right("Better Solutions", 9)  Result = Solutions
Right("Better", 1)  Result = r

INPUTS

RETURNS 

text    Returns the last or right most characters in a text string.

Search

Search(find_text, within_text [,start_num])

Locates one text string within a second text string, and return the number of the starting position of the first test string from the first character of the second text string.

EXAMPLE:

Search("e","Statements", 1)  Result = 5
Search("a?b", "AEB")  Result = 1 

INPUTS

RETURNS 

number    Returns the starting position of a substring within a larger text string.

Text

Text(value, format_text)

Changes the way a number appears by applying formatting to it with format codes.

EXAMPLE:

Text(2.715, "$0.00")  Result = $2.72
Text(37324, "dd/mm/yy")  Result = 09/03/02

INPUTS

RETURNS 

text    Returns the number as a formatted text string.

Trim

Trim(text)

Removes extra spaces in a text string from the beginning, middle and end.  Extra spaces can prevent your formula from working correctly.  The only space left will be a single space between words.

EXAMPLE:

Trim(" Better   Solutions ")  Result = Better Solutions

INPUTS

RETURNS 

text   Returns the text string with all extra spaces removed from the beginning, middle and end.

Upper

Upper(text)

Converts a text string so that all letters are uppercase.  Any characters that are not text will not be altered.  

EXAMPLE:

Upper("some text")  Result = SOME TEXT
Upper("BE MORE Productive")  Result = BE MORE PRODUCTIVE

INPUTS

RETURNS 

text    Returns the text string with all the characters converted to uppercase.

TABLE OF CONTENTS

• Formulas
• Writing Formulas
  • Basic Math
  • Comparisons
  • Using Functions
• Functions 
  • Date & Time
    • Date
    • DateDif
    • DateValue
    • Day
    • Days
    • EOMonth
    • Hour
    • Minute
    • Month
    • Now
    • Second
    • Time
    • TimeValue
    • Today
    • Weekday
    • WeekNum
    • Year
  • Information
    • IsBlank
    • IsEven
    • IsNonText
    • IsNumber
    • IsOdd
    • IsText
  • Logical
    • And
    • If
    • Not
    • Or
  • Math
    • ABS
    • Average
    • COS
    • COT
    • Even
    • EXP
    • INT
    • LN
    • LOG
    • LOG10
    • MAX
    • Median
    • MIN
    • MOD
    • MRound
    • ODD
    • PI
    • Power
    • Round
    • RoundDown
    • RoundUp
    • SIN
    • SQRT
    • SUM
    • TAN
    • TRUNC
  • Text
    • CHAR
    • Clean
    • Concatenate 
    • Dollar
    • Exact
    • Find
    • Fixed
    • Left
    • Len
    • Lower
    • Mid
    • NumberValue 
    • Proper
    • Replace
    • Right
    • Search
    • Text
    • Trim
    • Upper