Function Type: Text Description: Substitutes new text for old text in a text string. Function Structure: =SUBSTITUTE(text, old_text, new_text, [instance_num]). Argument Breakdown: text – The text to change. old_text – The text to replace. new_text – The text to replace with. instance_num – The instance to replace. If not supplied, all instances are replaced. Example:Continue reading “SUBSTITUTE function”
Tag Archives: Education
FIXED function
Function Type: Text Description: Formats a number as text with a fixed number of decimals. The result will be a text (alphanumeric) type. Function Structure: =FIXED(number, [decimals], [no_commas]). Argument Breakdown: number – The number to round and format. decimals – Number of decimals to use. Default is 2. no_commas – Suppress commas. TRUE = noContinue reading “FIXED function”
COUNTBLANK function
Function Type: Statistical Description: COUNTBLANK function in Excel or Google Sheets counts cells that are blank in a given range of cells specified. Literally just the empty / blank cells. Even a single space bar character or invisible texts (white font on white fill cell) on a cell well not be included in the countContinue reading “COUNTBLANK function”
COUNTA function
Function Type: Statistical Description: COUNTA function in Excel or Google Sheets counts cells that contain anything in a cell or a given range of cells. It counts even the errors, Boolean, AlphaNumerics or even a single space bar character. In my head, Excel or GSheets is counting AlphaNumerics which is short for CountA. Or maybeContinue reading “COUNTA function”
COUNT function
Function Type: Statistical Description: COUNT function in Excel or Google Sheets counts how many numbers are in the list of arguments. In my head, Excel or GSheets is counting the numbers in the specified arrays. It is very useful to me when summarizing data.It’s also useful when finding the average of a given data setContinue reading “COUNT function”
MINUTE function
Function Type: Date and Time Description: MINUTE function in Excel or Google Sheets is used to convert a serial number to a minute. “MINUTE” returns only the minute of the serial number, it ignores the hours and seconds. Minutes resets on 60-minute clock so if the serial number is more than 60 it will beContinue reading “MINUTE function”
EOMONTH function
Function Type: Date and Time Description: EOMONTH function in Excel or Google Sheets is used to return the serial number of the last day of the month before or after a specified number of months. Function Structure: =EDATE(start_date,months) Arguments start_date – this is the date or serial number representing the start date in a validContinue reading “EOMONTH function”
CHIDIST
Function Type: Compatibility Description: Returns the one-tailed probability of the chi-squared distribution. In Excel 2007, this is a Statistical function. Function Structure: =CHIDIST(x, deg_freedom). Argument Breakdown: x – The value at which the chi-square distribution is to be evaluated (must be ≥ 0). deg_freedom – The number of degrees of freedom (must be an integer between 1Continue reading “CHIDIST”
BINOMDIST
Function Type: Compatibility Description: Returns the individual term binomial distribution probability. In Excel 2007, this is a Statistical function. Function Structure: =BINOMDIST(number_s, trials, probability_s, cumulative) Argument Breakdown: number_s – The number of successes. trials – The number of independent trials. probability_s – The probability success on each trial. cumulative – TRUE = cumulative distribution function,Continue reading “BINOMDIST”