COLUMNS

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

COLUMN

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

XOR

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”

OR

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”

AND

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”

N

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