Office.com results
WEEKDAY function
Article Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default. Syntax WEEKDAY ( seria...
SharePoint Server 2007, Windows SharePoint Services 3.0
WEIBULL function
Article Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure. Syntax WEIBULL ( x , alpha...
SharePoint Server 2007, Windows SharePoint Services 3.0
FDIST function
Article Returns the F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can e...
SharePoint Server 2007, Windows SharePoint Services 3.0
FINV function
Article Returns the inverse of the F probability distribution. If p = FDIST(x,...), then FINV(p,...) = x. The F distribution can be used in an F-test that compares the ...
SharePoint Server 2007, Windows SharePoint Services 3.0
FIND function
Article Finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first charact...
SharePoint Server 2007, Windows SharePoint Services 3.0
FISHER function
Article Returns the Fisher transformation at x. This transformation produces a function that is approximately normally distributed rather than skewed. Use this function...
SharePoint Server 2007, Windows SharePoint Services 3.0
VARP function
Article Calculates variance based on the entire population. Syntax VARP ( number1 , number2 , ... ) Number1,number2, ...   are 1 to 30 number arguments corresponding t...
SharePoint Server 2007, Windows SharePoint Services 3.0
VARA function
Article Estimates variance based on a sample. In addition to numbers, text and logical values such as TRUE and FALSE are included in the calculation. Syntax VARA ( valu...
SharePoint Server 2007, Windows SharePoint Services 3.0
VARPA function
Article Calculates variance based on the entire population. In addition to numbers, text and logical values such as TRUE and FALSE are included in the calculation. Synt...
SharePoint Server 2007, Windows SharePoint Services 3.0
FISHERINV function
Article Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then F...
SharePoint Server 2007, Windows SharePoint Services 3.0
VALUE function
Article Converts a text string that represents a number to a number. Syntax VALUE ( text ) Text   is the text enclosed in quotation marks or a column reference containi...
SharePoint Server 2007, Windows SharePoint Services 3.0
EXPONDIST function
Article Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For examp...
SharePoint Server 2007, Windows SharePoint Services 3.0
USDOLLAR function
Article Converts a number to text using currency format, with the decimals rounded to the specified place. The format used is \$#,##0.00_);(\$#,##0.00). Syntax USDOLLAR (...
SharePoint Server 2007, Windows SharePoint Services 3.0
EXACT function
Article Compares two text strings and returns the logical value TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive. Use EXACT to test text bein...
SharePoint Server 2007, Windows SharePoint Services 3.0
VAR function
Article Estimates variance based on a sample. Syntax VAR ( number1 , number2 , ... ) Number1,number2,...   are 1 to 30 number arguments corresponding to a sample of a p...
SharePoint Server 2007, Windows SharePoint Services 3.0
FALSE function
Article Returns the logical value FALSE. Syntax FALSE ( ) Remark You can also type the word FALSE directly into the formula, and it is interpreted as the logical valu...
SharePoint Server 2007, Windows SharePoint Services 3.0
FACT function
Article Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number. Syntax FACT ( number ) Number   is the nonnegative number you want t...
SharePoint Server 2007, Windows SharePoint Services 3.0
EXP function
Article Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm. Syntax EXP ( number ) Number   is the expone...
SharePoint Server 2007, Windows SharePoint Services 3.0
UPPER function
Article Converts text to uppercase. Syntax UPPER ( text ) Text   is the text you want converted to uppercase. Text can be a column reference or text string. Example For...
SharePoint Server 2007, Windows SharePoint Services 3.0
TRUNC function
Article Truncates a number to an integer by removing the fractional part of the number. Syntax TRUNC ( number , num_digits ) Number   is the number you want to truncate...
SharePoint Server 2007, Windows SharePoint Services 3.0
TRUE function
Article Returns the logical value TRUE. Syntax TRUE () Remark You can enter the value TRUE directly without using this function. The TRUE function is provided primarily...
SharePoint Server 2007, Windows SharePoint Services 3.0
DEGREES function
Article Converts radians into degrees. Syntax DEGREES ( angle ) Angle   is the angle in radians that you want to convert. Example Formula Description (Result) =DEGREES(...
SharePoint Server 2007, Windows SharePoint Services 3.0
EVEN function
Article Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts ro...
SharePoint Server 2007, Windows SharePoint Services 3.0
TRIM function
Article Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular sp...
SharePoint Server 2007, Windows SharePoint Services 3.0
TODAY function
Article Returns the serial number of the current date. The serial number is the date-time code used for date and time calculations. You can use the TODAY function only ...
SharePoint Server 2007, Windows SharePoint Services 3.0
PREVNEXT
Didn't find what you were looking for?Search all of Office.com