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
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
RTD(ProgID,Server,Topic,[Topic2],…) [Category: Lookup & Reference]
New in Excel XP – Retrieves real-time data from a program that supports COM
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