The NORM.DIST Function Download the file The NORM.DIST function, as its name implies, returns the normal distribution (continuous probability function) given the mean and the standard deviation of your observations. The NORM.DIST function can return
Category Archives: Excel Formulas
The Data A user on MrExcel Forum asked, given two columns one with a start date and one with an end date, for an excel formula to count the number of days which fall within a
Excel Forecast Charts In the paragraphs below I will show how to calculate the different types of trendlines available in Excel charts: Linear, Exponential, Logarithmic, Polynomial, Power. Download the Excel file Given a data set
Ranking in Excel You can use two different function for ranking in Excel: RANK.EQ and RANK.AVG. These two functions do essentially the same job but return different results for the items in your data set that
Excel Dependent Drop Down Lists Using Tables A common question I see being asked on Excel forums is how to create Excel dependent drop down lists, that is to say that the list you get