Function Type: Statistical Description: COUNT function in Excel or Google Sheets counts how many numbers are in the list of arguments. In my head, Excel or GSheets is counting the numbers in the specified arrays. It is very useful to me when summarizing data.It’s also useful when finding the average of a given data setContinue reading “COUNT function”
Tag Archives: formula
PROPER function
Function Type: Text Description: PROPER function in Excel or Google Sheets capitalizes the first letter in each word of a text value. In my head, this is like when we write proper nouns, such as name of a person, city, events, etc. Which is why this function is named PROPER. Function Structure: =PROPER ( textContinue reading “PROPER function”
LOWER function
Function Type: Text Description: LOWER function in Excel or Google Sheets converts texts to lower cases. Function Structure: =LOWER ( text ) Argument Breakdown: text – The text you need to convert to lower case. Example: Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click oneContinue reading “LOWER function”
UPPER function
Function Type: Text Description: UPPER function in Excel or Google Sheets converts texts to UPPER CASE. Function Structure: =UPPER ( text ) Argument Breakdown: text – The text you need to convert to upper case. Example: Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click oneContinue reading “UPPER function”
YEARFRAC function
Function Type: Date and Time Description: YEARFRAC function in Excel or Google Sheets returns the year fraction representing the number of whole days between start_date and end_date. Function Structure: =YEARFRAC (start_date , end_date , [basis] ) Argument Breakdown: start_date – The date from which to start. end_date – The date from which to end. [basis]Continue reading “YEARFRAC function”
WORKDAY function
Function Type: Date and Time Description: WORKDAY function in Excel or Google Sheets returns the serial number of the date before or after a specified number of workdays. This function is useful in formulas when you need to know the any number of business days after the date today. Think of it as when youContinue reading “WORKDAY function”
WEEKNUM function
Function Type: Date and Time Description: WEEKNUM function in Excel or Google Sheets Converts a serial number to a number representing where the week falls numerically with a year. This function is useful in formulas when you need to know the week number, especially when you’re in the middle of the year where it getsContinue reading “WEEKNUM function”
NETWORKDAYS function
Function Type: Date and Time Description: NETWORKDAYS function in Excel or Google Sheets calculates the number of whole workdays between two dates. This function is useful in formulas where you need to calculate the number of weekdays or commonly known as business days. It will exclude the number of weekends in between the 2 datesContinue reading “NETWORKDAYS function”
TIMEVALUE
Function Type: Date and Time Description: TIMEVALUE function in Excel or Google Sheets is used to convert a time in the form of text to a serial number. This is best used when you have separate cells / placeholders for Hours, Minutes, and Seconds. It works even when you only have Hours and Minutes, itContinue reading “TIMEVALUE”