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”
Author Archives: googlemo123
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”
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”
Axie Infinity – Damage
You are probably here wondering how damage is calculated in Axie. You saw the damage in your enemy’s card Sinister Strike to be 130, but it dealt 179 to your Plant. One thing’s for sure, there is calculation to all these. 1. RPS Mechanics There are 9 different classes of Axies grouped into 3. EachContinue reading “Axie Infinity – Damage”
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: 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 “COLUMNS”
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: 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 tokensContinue reading “COLUMN”
CHOOSE
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: Still need helpContinue reading “CHOOSE”
AREAS
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: Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below. We can alsoContinue reading “AREAS”