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...

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...

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...

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 ...

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...

Article Returns the Fisher transformation at x. This transformation produces a function that is approximately normally distributed rather than skewed. Use this function...

Article Calculates variance based on the entire population. Syntax VARP ( number1 , number2 , ... ) Number1,number2, ...   are 1 to 30 number arguments corresponding t...

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...

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...

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...

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...

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...

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 (...

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...

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...

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...

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...

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...

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...

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...

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...

Article Converts radians into degrees. Syntax DEGREES ( angle ) Angle   is the angle in radians that you want to convert. Example Formula Description (Result) =DEGREES(...

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...

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...

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 ...