Category Archives: Education

Function Type: Lookup and Reference Description: Returns the number of columns in a reference. Function Structure: =COLUMNS(array). Argument Breakdown: array – A reference to a range of cells. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back to Learn Excel->

Function Type: Lookup and Reference Description: Returns the column number of a reference. Function Structure: =COLUMN(reference). Argument Breakdown: reference – A reference to a cell or range of cells. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back to Learn Excel->

Function Type: Lookup and Reference Description: Chooses a value from a list of values. Function Structure: =CHOOSE(index_num, value1, [value2]). Argument Breakdown: index_num – The value to choose. A number between 1 and 254. value1 – The first value from which to choose. value2 – The second value from which to choose. Example: If you needContinue reading “CHOOSE”

Function Type: Lookup and Reference Description: Returns the number of areas in a reference. Function Structure: =AREAS(reference). Argument Breakdown: reference – A reference to a cell or range of cells. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back to Learn Excel->

Version Availability: Desktop version starting Excel 2013 Function Type: Logical Description: Returns a logical exclusive OR of all arguments. Function Structure: =XOR(logical1, [logical2]). Argument Breakdown: logical1 – An expression, constant, or reference that evaluates to TRUE or FALSE. logical2 – An expression, constant, or reference that evaluates to TRUE or FALSE. Example: If you needContinue reading “XOR”

Function Type: Financial Description: Returns TRUE if any argument is TRUE. Function Structure: =OR(logical1, [logical2]). Argument Breakdown: logical1 – The first condition or logical value to evaluate. logical2 – The second condition or logical value to evaluate. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back toContinue reading “OR”

Function Type: Logical Description: Returns TRUE if all of its arguments are TRUE. Function Structure: =AND(logical1, [logical2]). Argument Breakdown: logical1 – This is the first condition or logical value to be evaluated. logical2 – This is the second condition or logical value to be evaluated. Example: If you need instant expert help with Excel orContinue reading “AND”

Function Type: Information Description: Returns a value converted to a number. Function Structure: =N(value). Argument Breakdown: value – The value to convert to a number. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back to Learn Excel->

Function Type: Information Description: Returns TRUE if the value is text. Function Structure: =ISTEXT(value). Argument Breakdown: value – This is the expression or value that needs to be tested. It is generally provided as a cell addess. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back toContinue reading “ISTEXT”