SUM function
By Saurabh Jain, in Functions,
- Read more...
-
- 0 comments
- 197 views
-
The Excel dictionary
-
Use this function to add the values in cells.
-
IF function
By Saurabh Jain, in Functions,
Use this function to return one value if a condition is true and another value if it's false. Here's a video about using the IF function.
- Read more...
-
- 0 comments
- 241 views
-
LOOKUP function
By Saurabh Jain, in Functions,
Use this function when you need to look in a single row or column and find a value from the same position in a second row or column.
- Read more...
-
- 0 comments
- 131 views
-
VLOOKUP function
By Saurabh Jain, in Functions,
Use this function when you need to find things in a table or a range by row. For example, look up an employee's last name by her employee number, or find her phone number by looking up her last name (just like a telephone book). Check out this video about using VLOOKUP.
- Read more...
-
- 0 comments
- 167 views
-
MATCH function
By Saurabh Jain, in Functions,
Use this function to search for an item in a range of cells, and then return the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 7, and 38, then the formula =MATCH(7,A1:A3,0) returns the number 2, because 7 is the second item in the range.
- Read more...
-
- 0 comments
- 96 views
-
CHOOSE function
By Saurabh Jain, in Functions,
Use this function to select one of up to 254 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.
- Read more...
-
- 0 comments
- 125 views
-
DATE function
By Saurabh Jain, in Functions,
Use this function to return the sequential serial number that represents a particular date. This function is most useful in situations where the year, month, and day are supplied by formulas or cell references. For example, you might have a worksheet that contains dates in a format that Excel does not recognize, such as YYYYMMDD.Use the DATEDIF function to calculate the number of days, months, or years between two dates.
- Read more...
-
- 0 comments
- 140 views
-
DAYS function
By Saurabh Jain, in Functions,
Use this function to return the number of days between two dates.
- Read more...
-
- 0 comments
- 139 views
-
FIND and FINDB locate one text string within a second text string. They return the number of the starting position of the first text string from the first character of the second text string.
- Read more...
-
- 0 comments
- 98 views
-
BETAINV function
By Saurabh Jain, in Functions,
Returns the inverse of the cumulative distribution function for a specified beta distribution
- Read more...
-
- 0 comments
- 99 views
-
BINOMDIST function
By Saurabh Jain, in Functions,
Returns the individual term binomial distribution probability
- Read more...
-
- 0 comments
- 134 views
-
CHIINV function
By Saurabh Jain, in Functions,
Returns the inverse of the one-tailed probability of the chi-squared distribution
- Read more...
-
- 0 comments
- 87 views
-
CHITEST function
By Saurabh Jain, in Functions,
Returns the test for independence
- Read more...
-
- 0 comments
- 89 views
-
CONFIDENCE function
By Saurabh Jain, in Functions,
Returns the confidence interval for a population mean
- Read more...
-
- 0 comments
- 132 views
-
COVAR function
By Saurabh Jain, in Functions,
Returns covariance, the average of the products of paired deviations
- Read more...
-
- 0 comments
- 104 views
-
EXPONDIST function
By Saurabh Jain, in Functions,
Returns the exponential distribution
- Read more...
-
- 0 comments
- 112 views
-
FDIST function
By Saurabh Jain, in Functions,
Returns the F probability distribution
- Read more...
-
- 0 comments
- 133 views
-
FINV function
By Saurabh Jain, in Functions,
Returns the inverse of the F probability distribution
- Read more...
-
- 0 comments
- 101 views
-
FLOOR function
By Saurabh Jain, in Functions,
Rounds a number down, toward zero
- Read more...
-
- 0 comments
- 113 views
-
FORECAST function
By Saurabh Jain, in Functions,
Calculates, or predicts, a future value by using existing values.
- Read more...
-
- 0 comments
- 101 views
-
FTEST function
By Saurabh Jain, in Functions,
Returns the result of an F-test
- Read more...
-
- 0 comments
- 116 views
-
GAMMADIST function
By Saurabh Jain, in Functions,
Returns the gamma distribution
- Read more...
-
- 0 comments
- 108 views
-
GAMMAINV function
By Saurabh Jain, in Functions,
Returns the inverse of the gamma cumulative distribution
- Read more...
-
- 0 comments
- 97 views
-
Returns the hypergeometric distribution
- Read more...
-
- 0 comments
- 105 views
-
LOGINV function
By Saurabh Jain, in Functions,
Returns the inverse of the lognormal cumulative distribution function
- Read more...
-
- 0 comments
- 107 views
-
Returns the cumulative lognormal distribution
- Read more...
-
- 0 comments
- 142 views
-
MODE function
By Saurabh Jain, in Functions,
Returns the most common value in a data set
- Read more...
-
- 0 comments
- 159 views
-
Returns the negative binomial distribution
- Read more...
-
- 0 comments
- 213 views
-
NORMDIST function
By Saurabh Jain, in Functions,
Returns the normal cumulative distribution
- Read more...
-
- 0 comments
- 168 views
-
NORMINV function
By Saurabh Jain, in Functions,
Returns the inverse of the normal cumulative distribution
- Read more...
-
- 0 comments
- 97 views
-