Function Type: Date and Time In most cases especially in our dashboards and summary sheets, we want to have the date today automatically. Description: TODAY function in Excel or Google Sheets returns the serial number of today’s date. This returns the date today based on the time and date on your computer. Whenever you openContinue reading “TODAY function”
Category Archives: Spreadsheet Tutorials — Excel and Google Sheets for Personal Finance
CONCATENATE function
Function Type: Text I’m sure not everyone knows what the word concatenate means so I’ll start this post with a screenshot of quick Google Search. Description: CONCATENATE function in Excel to concatenate (join) strings in a chain or series. Instead of using CONCATENATE, simply use the ampersand & operator.CONCATENATE will join texts together based onContinue reading “CONCATENATE function”
DATEDIF
Function Type: Date and Time Description: DATEDIF function calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.In my head, DATEDIF is short for Date Difference (Difference between Dates). Function Structure: =DATEDIF(start_date, end_date, unit) Argument Breakdown: start_date – Start date inContinue reading “DATEDIF”
Work as an Excel Expert at GotIt’s ExcelChat
Do you want to make money using your expertise with Excel or Google Sheets?
NOT function
Function Type: Logical Description: NOT function Reverses the logic of its argument.Any FALSE argument will result in TRUE.Any TRUE argument will result in FALSE. Logical test results in a TRUE or FALSE.Logical tests utilize Logical Operators. It can also be used together with IF function where we can assign two different results for when itContinue reading “NOT function”
ABS function
Function Type: Math and Trigonometry Description: ABS function returns the absolute (positive) value of a number.If you only want the positive or magnitude of the number, this is the function you are looking for. Function Structure: =ABS(number) Argument Breakdown: number – The number to get the absolute value of. Example: ABSolute of a negative ABSContinue reading “ABS function”
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”