Function Type: Logical Description: Specifies a logical test to perform. Function Structure: =IF(logical_test, [value_if_true], [value_if_false]). Argument Breakdown: logical_test – A value or logical expression that can be evaluated as TRUE or FALSE. value_if_true – The value to return when logical_test evaluates to TRUE. value_if_false – The value to return when logical_test evaluates to FALSE. Example:Continue reading “IF function”
Category Archives: Spreadsheet Tutorials — Excel and Google Sheets for Personal Finance
COUNTIF
Function Type: Statistical Description: Counts the number of cells within a range that meet the given criteria. Function Structure: =COUNTIF(range, criteria). Argument Breakdown: range – The range of cells to count. criteria – The criteria that controls which cells should be counted. Example: Still need help with Excel and Google Sheets? Get Instant Expert HelpContinue reading “COUNTIF”
COUNTIFS
Version Availability: Desktop version starting Excel 2019 Function Type: Statistical Description: Counts the number of cells within a range that meet multiple criteria. Function Structure: =COUNTIFS(range1, criteria1, [range2], [criteria2]). Argument Breakdown: range1 – The first range to evaluate. criteria1 – The criteria to use on range1. range2 – The second range to evaluate. criteria2 –Continue reading “COUNTIFS”
UNIQUE Function
Function Type: Lookup and Reference Description: Returns a list of unique values in a list or range Function Structure: =UNIQUE(array, [column?], [distinct?]). Argument Breakdown: array – The list array or range to find the unique values from. [column?] – Is it by column? TRUE or FALSE [distinct?] – Do you want the values that appearsContinue reading “UNIQUE Function”
SUMPRODUCT Function
Function Type: Math and Trigonometry Description: Returns the sum of the products of corresponding array components. Function Structure: =SUMPRODUCT(array1, [array2], [array3]). Argument Breakdown: array1 – The first array or range to multiply, then add. array2 – The second array or range to multiply, then add. array3 – The third array or range to multiply thenContinue reading “SUMPRODUCT Function”
TRIM function
Function Type: Text Description: Removes spaces from text. Function Structure: =TRIM(text). Argument Breakdown: text – The text from which to remove extra space. Example: Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below. We can also accept LEO, HIVE, HBD tokens as payment if we transact directlyContinue reading “TRIM function”
RIGHT, RIGHTB function
Function Type: Text Description: Returns the rightmost characters from a text value. Function Structure: =RIGHT, RIGHTB(text, [num_chars], [num_bytes]). Argument Breakdown: text – The text string containing the characters you want to extract. num_chars – Specifies the number of characters you want RIGHT to extract. num_bytes – Specifies the number of characters you want RIGHTB toContinue reading “RIGHT, RIGHTB function”
LEN, LENB function
Function Type: Text Description: Returns the number of characters in a text string. Function Structure: =LEN, LENB(text). Argument Breakdown: text – The text for which to calculate length. Example: Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below. We can also accept LEO, HIVE, HBD tokens asContinue reading “LEN, LENB function”
SUBSTITUTE function
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”