Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
bytes each character uses, from the ﬁ rst character of within_text. This function
is for use with double-byte characters. You can also use SEARCHB to ﬁ nd one
text string within another.
Returns the inverse of the F probability distribution. If p = FDIST(x,...), then
FINV(p,...) = x.
FISHER(x) [Category: Statistical]]
Returns the Fisher transformation at x. This transformation produces a function
that is approximately normally distributed rather than skewed. Use this function
to perform hypothesis testing on the correlation coefﬁ cient.
FISHERINV(y) [Category: Statistical]]
Returns the inverse of the Fisher transformation. Use this transformation when
analyzing correlations between ranges or arrays of data. If y = FISHER(x), then
FISHERINV(y) = x.
FIXED(number,decimals,no_commas) [Category: Text]
Rounds a number to the speciﬁ ed number of decimals, formats the number in
decimal format using a period and commas, and returns the result as text. Guru
Tip: =TEXT(number,"0.00") would do the same thing, with additional ﬂ exibility.
FLOOR(number,signiﬁ cance) [Category: Math]
Rounds number down, toward zero, to the nearest multiple of signiﬁ cance. Guru
Tip: CEILING will round up to the nearest nickel, which seems a more likely
FORECAST(x,known_y’s,known_x’s) [Category: Statistical]]
Calculates, or predicts, a future value by using existing values. The predicted
value is a y-value for a given x-value. The known values are existing x-values
and y-values, and the new value is predicted by using linear regression. You can
use this function to predict future sales, inventory requirements, or consumer
trends. Guru Tip: FORECAST is used with linear progression. Cells B25:B29 of
this image use FORECAST to predict future sales. This is theoretically easier
than calculating =INTERCEPT()+SLOPE()*A25. Also see LINEST, INTERCEPT,