Skip to search results
PRODUCT
Office.com results
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
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
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
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
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
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
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
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
DOLLAR 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 DOLLAR ( n...
SharePoint Server 2007, Windows SharePoint Services 3.0
TINV function
Article Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. Syntax TINV ( probability , degrees_freedom ) P...
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
DEVSQ function
Article Returns the sum of squares of deviations of data points from their sample mean. Syntax DEVSQ ( number1 , number2 , ... ) Number1,number2, ...   are 1 to 30 argu...
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
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
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
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
TDIST function
Article Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points ...
SharePoint Server 2007, Windows SharePoint Services 3.0
DATE function
Article Returns the sequential serial number that represents a particular date. Syntax DATE ( year , month , day ) Year   The year argument can be one to four digits. ...
SharePoint Server 2007, Windows SharePoint Services 3.0
CRITBINOM function
Article Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Use this function for quality assurance...
SharePoint Server 2007, Windows SharePoint Services 3.0
TANH function
Article Returns the hyperbolic tangent of a number. Syntax TANH ( number ) Number   is any real number. Remark The formula for the hyperbolic tangent is: Examples Formu...
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
DATEDIF function
Article Calculates the number of days, months, or years between two dates. This function is provided for compatibility with Lotus 1-2-3. Syntax DATEDIF ( start_date , e...
SharePoint Server 2007, Windows SharePoint Services 3.0
DAYS360 function
Article Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to...
SharePoint Server 2007, Windows SharePoint Services 3.0
Didn't find what you were looking for?Search all of Office.com