Formulas

AVERAGE

The AVERAGE function can be used to find the average or arithmetic mean of a list of numbers.

The syntax for the AVERAGE function is:

= AVERAGE (Argument1,[Argument2], ... ,[Argument N] )

 

AND

The AND function is one of many Logical Functions. Like most logical functions, the output from the AND function is either the word TRUE or FALSE.

To determine whether the output will be TRUE or FALSE, the function evaluates at least one mathematical expression located in another cell

The Syntax for the AND function is:

=AND( Condition1, [Condition2],....[Condition N])

Example:

  =AND (TextBox1 > 100, TextBox2 >100, TextBox3 > 100)

If all three of these cells (TextBox1,TextBox2, and TextBox3) contain a value greater than 100, the output for the AND function will be TRUE. If any of these cells have numbers less than or equal to 100, the output for the AND function will be FALSE.

 

ADDDAY

The ADDDAY function can be used to add the number of days to the selected date.

The syntax for ADDDAY function is:

=ADDDAY( Date, Days to Add)

Example

=ADDDAY(Calendar, 3)

At the runtime, choose the date from the calendar and output for ADDDAY function is date after three days from the chosen date.

 

ADDMONTH

The ADDMONTH function can be used to add the number of months to the selected date.

The syntax for ADDMONTH function is:

=ADDMONTH(Date, Months to Add)

Example:

=ADDMONTH (Calendar, 3)

At the runtime, choose the date from the calendar and output for ADDMONTH function is date after three months from the chosen date.

 

ADDYEAR

The ADDYEAR function can be used to add the number of years to the selected date.

The syntax for ADDYEAR function is:

=ADDYEAR (Date, Years to Add)

Example:

= ADDYEAR (Calendar, 3)

At the runtime, choose the date from the calendar and output for ADDYEAR function is date after three years from the chosen date.

 

CONCAT

The CONCATENATE function  is used to join two or more words or text strings together.

The syntax for the CONCATENATE function is:

= CONCAT (Argument1, [Argument2], ... ,[Argument N])

Example:

=CONCAT(FirstName," ",LastName)

Arguments can be words, blank spaces or numbers.

 

DAY

The Day function can be used to find day for the date.

The syntax for DAY function is:

=DAY(Date)

Example:

=  DAY(Calendar) i.e. 2013-12-30

At the runtime, choose the date from the calendar and output for DAY function is only day of selected date. i.e. 30

 

INR

The INR function can be used to increment chosen field by the number given.

The syntax for INR function is:

=INR(Seed, increment)

Example:

=INR(TextBox1, 3) TextBox1 should be integer or float.

At the runtime, output for INR function is number in TextBox1 is incremented by 3

 

IF

The IF function introduces decision making into a sheet. Depending on whether or not certain criteria is met, you can have the function place different results in one or more cells.

The syntax for IF function is:

=IF(Condition, True Expression, [False Expression])

Example:

=IF( TextBox1=100, “True value”, ”false value”)

At the runtime, output is True value if TextBox1 is 100 otherwise output is false value.

 

MIN

The MIN function is used to find the smallest or minimum value.

If the range selected for the function contains blank cells or cells containing text data, these cells are ignored by the function.

The syntax for the MIN function is:

=MIN(Argument1, [Argument2], ... [Argument N])

 

MAX

The MAX function is used to find the largest or maximum value.

If the range selected for the function contains blank cells or cells containing text data, these cells are ignored by the function.

The syntax for the MAX function is:

=MAX(Argument1, [Argument2], ... [Argument N])

 

MONTH

The Month function can be used to find month for the date.

The syntax for MONTH function is:

=MONTH (Date)

Example:

= MONTH(Calendar) i.e. 2013-12-30

At the runtime, choose the date from the calendar and output for MONTH function is only month of selected date (i.e. 12)

 

OR

The OR function is one of Logical Functions. Like most logical functions, the output from the OR function is either the word TRUE or FALSE.

To determine whether the output will be TRUE or FALSE, the function evaluates at least one mathematical expression located in another cell

The Syntax for the OR function is:

=OR(Condition1, [Condition2],...[Condition N])

Example:

=OR(TextBox1 > 100, TextBox2 >100, TextBox3 > 100)

If one of three of these cells (TextBox1, TextBox2, and TextBox3) contain a value greater than 100, the output for the OR function will be TRUE. If all these cells have numbers less than or equal to 100, the output for the OR function will be FALSE.

 

ROUND

The ROUND function is used to reduce a given value to a specific number of decimal places.

The syntax for the ROUND function is:

=ROUND(Number, Decimal place )

 

SUM

The SUM function is used to add the numbers

The syntax for the SUM function is:

=SUM(Argument1, [Argument2],...,[Argument N])

 

SUBTRACTDAY

The SUBTRACTDAY function can be used to subtract the number of days from the selected date.

The syntax for SUBTRACTDAY function is:

=SUBTRACTDAY(Date, Days to subtract)

Example:

=SUBTARCTDAY(Calendar, 3)

At the runtime, choose the date from the calendar and output for SUBTRACTDAY function is date before three days from the chosen date

 

SUBTRACTMONTH

The SUBTRACTMONTH function can be used to subtract the number of months from the selected date.

The syntax for SUBTRACTMONTH function is:

=SUBTRACTMONTH(Date, Months to Subtract)

Example:

= SUBTARCTMONTH(Calendar, 3)

At the runtime, choose the date from the calendar and output for SUBTRACTMONTH function is date before three months from the chosen date

 

SUBTRACTYEAR

The SUBTRACTYEAR function can be used to subtract the number of years from the selected date.

The syntax for SUBTRACTYEAR function is:

=SUBTRACTYEAR( Date, Years to Subtract)

Example:

= SUBTARCTYEAR(Calendar, 3)

At the runtime, choose the date from the calendar and output for SUBTRACTDAY function is date before three years from the chosen date

 

YEAR

The Year function can be used to find year for the date.

The syntax for YEAR function is:

=YEAR(Date)

Example:

= YEAR(Calendar) i.e. 2013-12-30

At the runtime, choose the date from the calendar and output for YEAR function is only year of selected date. i.e. 2013

 

Have more questions? Submit a request

Comments

Powered by Zendesk