vert line

ABS or @ABS

Computes the absolute value of the given number.

ABS(num)

num any number

The absolute value of a number is the value of the number ignoring positive or negative indicators. The absolute value of a positive number is given as the number. The absolute value of a negative number would be that number multiplied by negative one (-1); in other words the same number, except positive.

=ABS(-45.3) -> 45.3

@ABS(-45.3) -> 45.3

=ABS(COS(PI)) -> 1

=ABS(34) -> 34

=ABS("Absolutely!") -> 0

ACOSor @ACOS

Returns the arccosine of the given number.

ACOS(num)

num any number between -1 and 1

The arccosine of the number num is the angle whose cosine is num. The ACOS function gives the value of the angle in radians; the value of the angle can be obtained in degrees by using this function in conjunction with the RADTODEG function. See "RADTODEG or @RADTODEG".

=ACOS(0.7071) -> 0.7854 (radians) : This is equal to an angle of 45 degrees.

@RADTODEG(@ACOS(0.7071)) -> 45 : This gives the same answer as above, but in degrees.

ASINor @ASIN

Returns the arcsine of the given number.

ASIN(num)

num any number between -1 and 1

The arcsine of the number num is the angle whose sine is num. The ASIN function gives the value of the angle in radians; the value of the angle can be obtained in degrees by using this function in conjunction with the RADTODEG function. See "RADTODEG or @RADTODEG".

=ASIN(0.3090) -> 0.3141 (radians) : This is equal to an angle of 18 degrees.

@RADTODEG(@ASIN(0.3090)) -> 18 : This gives the same answer as above, but in degrees.

ATANor @ATAN

Returns the arctangent of the given number.

ATAN(num)

num any number

The arctangent of the number num is the angle whose tangent is num. The ATAN function gives the value of the angle in radians; the value of the angle can be obtained in degrees by using this function in conjunction with the RADTODEG function. See "RADTODEG or @RADTODEG".

=ATAN(5.6713) -> 1.3963 (radians) : This is equal to an angle of 80 degrees.

ATAN2

Returns the arctangent of the ratio of the given X and Y coordinates.

ATAN2(x, y)

x any number

y any number

The ATAN2 function finds the angle between the X axis and the point with the given coordinates x and y. This gives the angle of a line from the origin (0,0) to the point (x,y). The ATAN2 function gives the value of the angle in radians; the value of the angle can be obtained in degrees by using this function in conjunction with the RADTODEG function. See "RADTODEG or @RADTODEG".

=ATAN2(1,3) -> 0.3218 (radians) : This is equal to an angle of 18.4 degrees.

@ATAN2

Returns the arctangent of the ratio of the given Y and X coordinates.

@ATAN2(y, x)

y any number

x any number

@ATAN2 finds the angle between the X axis and the point with the given coordinates x and y. This gives the angle of a line from the origin (0,0) to the point (x,y). The @ATAN2 function gives the value of the angle in radians; the value of the angle can be obtained in degrees by using this function in conjunction with the RADTODEG function. See "RADTODEG or @RADTODEG".

@ATAN2(3,1) -> 0.3217 (radians): This is equivalent to an angle of 18.4 degrees.

ATAN2 and @ATAN2 are different functions. ATAN2 requires the x parameter to be first, whereas @ATAN@ requires the y parameter to be first.

AVEor AVERAGE

Computes the average, or mean, of a list of numeric values. Strings are ignored.

AVE(num, ...), AVE(range), AVE(range1, range2, range3,...)

num any number

range any worksheet range

Divides the sum of the given numbers by the count of numeric entries. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. String entries are ignored and have no effect on the result.

=AVERAGE(4,5,25,3) -> 9.25

Given the following data:

A1: 184

A2: 592

A3: 97

=AVE(A1:A3) -> 291

@AVEor @AVG

Computes the average, or mean, of a list of numeric values. Strings are treated as zero values.

@AVE(num,...), @AVE(range), @AVE(range1, range2, range3,...)

num any number

range any worksheet range

Divides the sum of the given numbers by the count of numeric entries. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. String entries are treated as zero and are computed into the result.

@AVE(4,5,25,3) = 9.25

Given the following data:

A1: 184

A2: 592

A3: 97

@AVE(A1:A3) = 291

AVE and AVERAGE are different from @AVE and @AVG in that AVE and AVERAGE ignore string values, while @AVE and @AVG treat string values as having a zero value.

COSor @COS

Returns the cosine of the given number.

COS(num)

num any number

The cosine of the angle num is the X coordinate of the point where a line at that angle from the X axis intersects a circle of radius one (1) centered on the origin (0,0). The COS function takes the value of the angle in radians; the value of the angle can be converted from degrees to radians within this function by using it in conjunction with the DEGTORAD function. See "DEGTORAD or @DEGTORAD".

=COS(PI) -> -1

@COS(LN(3)) -> 0.4548

COUNT

Counts the number of numeric entries. Cells or items containing blanks or strings are not counted.

COUNT(num , ...), COUNT(range),

COUNT(range1, range2, ...)

num any number

range any worksheet range

The COUNT function finds the number of numeric entries in the list of arguments, and ignores string values. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments.

A B

1 Duck 10

2 Soup 20

3 1.86 20

4 $300 10

5 '====== 30

6 50

7 40 70

=COUNT(A1:A7) -> 3 : There are only three items in column A because cells A1, A2, and A5 are strings and A6 is blank.

=COUNT(A1:A7,B1:B7) -> 10 : This counts the 3 items in column A and the 7 items in column B.

=COUNT("Good","Bad","Indifferent",0) -> 1

@COUNT

Counts the number of numbers and strings given.

@COUNT(num, ...), @COUNT(range),

@COUNT(range1, range2, ...)

num any number

range any worksheet range

The @COUNT function finds the number of numeric or string entries in the list of arguments. Cells or items containing strings are counted. Cells or items containing blanks are not counted. You may list any combination of numbers, cell addresses, and ranges as arguments.

A B

1 Duck 10

2 Soup 20

3 1.86 20

4 $300 10

5 '====== 30

6 50

7 40 70

@COUNT(A1:A7) = 6: There are only six items in column A because cell A6 is blank.

@COUNT(A1:A7,B1:B7) = 13: This counts the 6 items in column A and the 7 items in column B.

@COUNT("Good","Bad","Indifferent") = 3

COUNT and @COUNT are different in that COUNT only counts numeric values. @COUNT also counts string values.

DEGTORADor @DEGTORAD

Converts the given number from degrees to radians.

DEGTORAD(num)

num any number

Angles can be expressed in units of degrees or radians. There are 360 degrees, or 2p radians in a circle. All of Mesa's trigonometric functions express angles in radians. This function will allow you to convert angles given in degrees to radians for use in Mesa's trigonometric functions. Radians can be converted to degrees using the RADTODEG function. See "RADTODEG or @RADTODEG" .

=DEGTORAD(180) -> 3.14159

DIVor @DIV

Divides the given number by the given divisor and returns an integer.

DIV(num, div)

num any number

div any non-zero number

This function divided the given number by the given divisor and returns the integer portion of the answer. The remainder can be obtained using the MOD function. See "MOD or @MOD" .

=DIV(12,5) -> 2

EXPor @EXP

Raises e the power of the given number.

EXP(num)

num any real number

EXP raises e to the given power. The number e is defined to be the number such that the derivative of enum is enum. The number e is approximately 2.71828. The natural logarithm of enum is num. see "LN or @LN".

=EXP(4) -> 54.5982

@EXP(12%*5) * 30000 -> $54,664 : This formula calculates the present value of $30,000 invested at 12% continually compounded interest for a term of 5 years.

FRACor @FRAC

Returns the fractional component of the given number.

FRAC(num)

num any number

FRAC returns the non-integer portion of the given number, num. This function complements the INT function, see "INT or @INT".

=FRAC(NOW) : This formula returns only the time component of the current date.

@FRAC(3.14159) -> 0.14159

INTor @INT

Returns the integer portion of the given number.

INT(num)

num any number

INT returns the integer portion of the given number, num. This does not round the number off, it simply ignores all digits to the right of the decimal point. This function complements the FRAC function, see "FRAC or @FRAC".

=INT(RAND*10) : This formula returns a random number between 0 and 9.

A3: 68293

@INT(LOG(A3))+1 -> 5 : This formula tells how many digits are the number in cell A3.

LNor @LN

Returns the natural logarithm of the given number.

LN(num)

num any positive number

The natural logarithm of a number is the power to which e needs to be raised to result in the given number; in other words, the logarithm to base e. The number e is defined to be the number such that the derivative of enum is enum. The number e is approximately 2.71828. If the natural logarithm of num is raised to the power e, the result is num. see "EXP or @EXP".

=LN(27) -> 3.2958

B8: 1024

=LN(B8)/LN(2) -> 10 : This formula returns the base 2 log of cell B8.

LOG, LOG10 or @LOG

Returns the base ten (10) logarithm of given number.

LOG(num)

num any positive number

The base ten (10) logarithm of a number is the power to which ten needs to be raised in order to result in the given number.

=LOG10(45) -> 1.6532

+10^(LOG(292)) -> 292 : This formula takes the base 10 log of 292, then raises 10 to that power, resulting in the number it began with.

MAX

Returns the largest number in the given range or list.

MAX(num,...), MAX(range), MAX(range1, range2,...)

num any number

range any worksheet range

MAX returns the largest number in a given list or range, ignoring strings and non-numeric input. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments.

=MAX(4.5,3.2,2.5,2.5,6.2) -> 6.2

=MAX(4,4,4) -> 4

A B C

1 300 400

2 0 400

3 200 100

4 300 5000

5 700

6 600

7 300

8 500

=MAX(A1:A8,C1:C8) -> 5000

@MAX

Returns the largest number in the given range or list with strings considered to be zero.

@MAX(num,...), @MAX(range), @MAX(range1, range2,...)

num any number

range any worksheet range

@MAX returns the largest number in a given list or range. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. Strings are treated as having a value of zero.

@MAX(4.5,3.2,2.5,2.5,6.2) = 6.2

@MAX(4,4,4) = 4

A B C

1 300 400

2 0 400

3 200 100

4 300 5000

5 700

6 600

7 300

8 500

@MAX(A1:A8,C1:C8) -> 5000

MAX() and @MAX() differ in that MAX() ignores string values, while @MAX treats string values as zero.

MIN

Results in the smallest number in the given range or list.

MIN(num,...), MIN(range), MIN(range1, range2,...)

num any number

range any worksheet range

MIN returns the smallest number in a given list or range, ignoring strings and non-numeric input. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments.

A1: 300, A2: 400, A3: Hello!

=MIN(A1:A3) -> 300 : This formula returns 300, and the string entry in cell A3 is ignored.

A1: 0.0002, A2: 0, A3: -339492

+MIN(A1:A3) -> -339492

@MIN

Returns the smallest number in the given range or list, with string values considered to be zero.

@MIN(num,...), @MIN(range), @MIN(range1, range2,...)

num any number

range any worksheet range

@MIN returns the smallest number in a given list or range. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. Strings are treated as having a value of zero.

A1: 300

A2: 400

A3: Hello!

@MIN(A1:A3)-> 0 : This formula returns zero because the string "Hello!" evaluates to zero.

A1: 0.0002

A2: 0

A3: -339492

@MIN(A1:A3) -> -339492

MIN() and @MIN() differ in that MIN() ignores string vales while @MIN() treats strings as having a value of zero.

MODor @MOD

Returns the remainder of the given number divided by the given divisor.

MOD(num, div)

num any number

div any non-zero number

MOD compliments the DIV function (see "DIV or @DIV") by returning the portion of the given number that does can not be divided evenly by the given divisor.

=MOD(12,5) -> 2

@NOW-@MOD(@NOW,7)+5 : This function returns the date-number for Monday of the current week.

PROD

Multiplies all the numbers in the given list.

PROD(num, ...), PROD(range), PROD(range1, range2, ...)

num any number

range any worksheet range

PROD takes the product of all the numbers in the given list. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. Strings within the list are ignored.

=PROD(3, 5, 10, 2) -> 300

A1: 3

A2: 5

B1: 10

=PROD(A1:A2, B1, 2) -> 300

@PROD

Multiplies all the numbers in the given list. Strings are treated as having a value of zero.

PROD(num, ...), PROD(range), PROD(range1, range2, ...)

num any number

range any worksheet range

PROD takes the product of all the numbers in the given list. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. Strings within the list are treated as having a value of zero, so if a string appears in the list, PROD will return zero.

@PROD(3, 5, 10, 2) -> 300

A1: 3

A2: 5

B1: 10

@PROD(A1:A2, B1, 2) -> 300

PROD and @PROD differ in that PROD ignores strings, while @PROD treats strings as having a value of zero.

RADTODEGor @RADTODEG

Converts the given number from radians to degrees.

RADTODEG(num)

num any number

Angles can be expressed in units of degrees or radian. There are 360 degrees, or 2p radians in a circle. All of Mesa's trigonometric functions express angles in radians. This function will allow you to convert angles given in radians by Mesa's trigonometric functions to degrees. Degrees can be converted to radians using DEGTORAD. See "DEGTORAD or @DEGTORAD".

=RADTODEG(PI) -> 180

ROOTor @ROOT

Returns the given root of the given number.

ROOT(num, n)

num any positive number

n any number

This function can be used to find the n th root of a number, num. The n th root of a number num is the number that, multiplied by itself n times, returns the number num.

=ROOT(81,4) -> 3

ROUNDor @ROUND

Rounds a number to a given number of decimal places.

ROUND(num, prec)

num any number

prec any integer

This function rounds the number num to prec decimal places. If prec is zero, the number is rounded to the nearest integer. If prec is greater that zero, it will round off prec places beyond the decimal point. If prec is less than zero, it rounds to the left of the decimal place.

=ROUND(350.2852,2) -> 350.29

@ROUND(25492,-3) -> 25000

SGN, SIGN, @SIGN, or @SGN

Determines whether a number is positive or negative.

SGN(num)

num any number

This function returns 0 if num is zero, -1 if num is less than 0, and 1 if num is greater than 0. This functions is useful in conjunction with other functions where it is necessary to determine whether a number is positive, negative, or zero.

B7: +RAND

=SIGN(B7-0.5) : This formula returns -1, 0, or 1 randomly.

=SGN(-405) -> -1

SINor @SIN

Computes the sine of the given number.

SIN(num)

num any number

The sine of an angle is the Y coordinate of the point where a line at that angle from the X axis intersects a circle of radius one (1) centered on the origin. The SIN function takes the value of the angle in radians; the value of the angle can be converted from degrees to radians within this function by using it in conjunction with the DEGTORAD function. See "DEGTORAD or @DEGTORAD".

=SIN(60*PI/180) = 0.8660 : This formula gives the sine of 60 degrees.

A mountain road goes up at an incline of 25 degrees. If the road is straight and is 20 miles long, what vertical distance will a car travel to climb it? The formula is +20 * SIN(25*(pi/180)) -> 8.45 miles

SQRTor @SQRT

Calculates the square root of a number.

SQRT(num)

num any positive number

This function finds the positive number which, when multiplied by itself, yields the number num. To find roots other than the square root, see "ROOT or @ROOT".

=SQRT(34) -> 5.8310

@SQRT(@LOG(200)) -> 1.5169

=SQRT(VAR(200,500,100)) -> 170 : This formula computes the standard deviation of the values given in the variance function.

STDDEVor STDEV

Returns the standard deviation of the ranges or list. Blank cells and strings are not counted.

STDDEV(num,...), STDDEV(range),

STDDEV(range1, range2,...)

num any number

range any worksheet range.

This function finds the standard deviation of the given range or list of numbers. The items in the list are separated by commas, and they may be numbers or cell or range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. The standard deviation is a measure of the statistical distribution of a set of numbers.

A B

1 NAME SCORE

2 Anna 65.8

3 Bill 95.4

4 Donna 30.2

5 Mark 54.9

6 Maria 35.1

7 Susan 75.9

8 John 83.2

9 Rob 33.1

10 Ethan 81.8

=STDEV(B2:B10) -> 23.1

@STD

Returns the standard deviation of the ranges or list. Strings are counted as 0, and blank cells are not counted.

@STD(num,...), @STD(range), @STD(range1, range2,...)

num any number

range any worksheet range

This function finds the standard deviation of the given range or list of numbers. The items in the list are separated by commas, and they may be numbers or cell or range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. Strings within the list are treated as having a value of zero. The standard deviation is a measure of the statistical distribution of a set of numbers.

A B

1 NAME SCORE

2 Anna 65.8

3 Bill 95.4

4 Donna 30.2

5 Mark 54.9

6 Maria 35.1

7 Susan 75.9

8 John 83.2

9 Rob 33.1

10 Ethan 81.8

@STD(B2:B10) -> 23.1

STDDEV() and STDEV() differ from @STD() in that STDDEV() and STDEV() ignore string values while @STD() treats string values as zero.

SUMor @SUM

Adds all the numbers in a list.

SUM(num,...), SUM(range), SUM(range1, range2,...)

num any number

range any worksheet range

This function finds the sum of all the numbers in the given list or range. The items in the list are separated by commas, and they may be numbers or cell or range references containing numbers. You can specify as many numbers or ranges as you want. You may list any combination of numbers, cell addresses, and ranges as arguments.

=SUM(300,400,2300,100) -> 3100

A1: Blue

A2: 300

A4: 900

B1: 1200

=SUM(A1:A4,B1) -> 2400

TANor @TAN

Returns the tangent of the given number.

TAN(num)

num any number

The tangent of an angle is ratio of the Y coordinate to the X coordinate of the point where a line at that angle from the X axis intersects a circle of radius one (1) centered on the origin. The TAN function takes the value of the angle in radians; the value of the angle can be converted from degrees to radians within this function by using it in conjunction with the DEGTORAD function. See "DEGTORAD or @DEGTORAD".

=TAN(1.24) -> 2.9119

VAR

Calculates the statistical variance of a list of numbers. Strings and blank cells are not counted.

VAR(num,...), VAR(range), VAR(range1, range2,...)

num any number

range any worksheet range

This function finds the statistical variance of a range of list of numbers. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. Variance is a measure of how much a set of numbers vary from each other. Strings and blank cells in the list are ignored.

A B

1 NAME SCORE

2 Anna 65.8

3 Bill 95.4

4 Donna 30.2

5 Mark 54.9

6 Marie 35.1

7 Susan 75.9

8 John 83.2

9 Rob 33.1

10 Ethan 81.8

=VAR(B2:B10) -> 531.6010

@VAR

Calculates the statistical variance of a list of numbers. Strings are counted as 0, and blank cells are not counted.

@VAR(num,...), @VAR(range), @VAR(range1, range2,...)

num any number

range any worksheet range

This function finds the statistical variance of a range of list of numbers. The items in the list are separated by commas, and they may be numbers or cell/range references containing numbers. You may list any combination of numbers, cell addresses, and ranges as arguments. Variance is a measure of how much a set of numbers vary from each other. This function is essentially the same as VAR, except that it treats strings as having a value of zero.

A B

1 NAME SCORE

2 Anna 65.8

3 Bill 95.4

4 Donna 30.2

5 Mark 54.9

6 Marie 35.1

7 Susan 75.9

8 John 83.2

9 Rob 33.1

10 Ethan 81.8

@VAR(B2:B10) = 531.6010

VAR and @VAR are different in that VAR ignores strings while @VAR treats string values as zero.

 

Also go to:

Index help

Contents help