Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

ROWS(array) [Category: Lookup & Reference]

Returns the number of rows in a reference or array. Guru Tip: You might use

ROWS to ﬁ gure out how many rows are returned by a dynamic range generated

by OFFSET.

RSQ(known_y’s,known_x’s) [Category: Statistical]]

Returns the square of the Pearson product moment correlation coefﬁ cient

through data points in known_y’s and known_x’s. The r-squared value can be

interpreted as the proportion of the variance in y attributable to the variance in

x.

RTD(ProgID,Server,Topic,[Topic2],…) [Category: Lookup & Reference]

New in Excel XP – Retrieves real-time data from a program that supports COM

automation.

SEARCH(ﬁ nd_text,within_text,start_num) [Category: Text]

SEARCH returns the number of the character at which a speciﬁ c character or

text string is ﬁ rst found, beginning with start_num. Use SEARCH to determine

the location of a character or text string within another text string so that you

can use the MID or REPLACE functions to change the text. Guru Tip: SEARCH

is more ﬂ exible than the more popular FIND function. SEARCH allows for

wildcards in ﬁ nd_text. Also, SEACH is not case-sensitive, so there is no need to

use LOWER to modify within_text as you might have to do with FIND.

SEARCHB(ﬁ nd_text,within_text,start_num) [Category: Text]

SEARCHB also ﬁ nds one text string (ﬁ nd_text) within another text string (within_

text), and returns the number of the starting position of ﬁ nd_text. The result is

based on the number of bytes each character uses, beginning with start_num.

This function is for use with double-byte characters You can also use FINDB to

ﬁ nd one text string within another.

SECOND(serial_number) [Category: Date & Time]

Returns the seconds of a time value. The second is given as an integer in the

range 0 (zero) to 59.

SERIESSUM(x,n,m,coefﬁ cients) [Category: Math]*

Returns the sum of a power series based on the formula:

SERIES(x,n,m,a) » a1xn + a2x(n+m) + a3x(n+2m) + ... + aix(n+(i-1)m)

SIGN(number) [Category: Math]

Determines the sign of a number. Returns 1 if the number is positive, zero (0) if

the number is 0, and -1 if the number is negative.

SIN(number) [Category: Math]

Returns the sine of the given angle. Guru Tip: While the sine function that you

learned about in geometry dealt with degrees, Excel’s function needs a number of

radians as an argument. To ﬁ nd the sine of 90 degrees, use =SIN(RADIANS(90)).

In the ﬁ gure below, three sine waves ﬁ gure out the current day’s biorhythm

chart.