QUOTIENT function: Returns one number divided by another, without the remainder. Sample Usage: =QUOTIENT(4,2) =QUOTIENT(A2,B2) Syntax =QUOTIENT(dividend, divisor) dividend – The number to be divided. divisor – The number to divide by (cannot equal 0). The QUOTIENT function in Google Sheets is a useful tool for performing division and returning only the integer result of … Read more
ARABIC Computes the value of a Roman numeral. Sample Usage ARABIC(“XIV”) ARABIC(“MMXIII”) Syntax ARABIC(roman_numeral) roman_numeral – The Roman numeral to format, whose value must be between 1 and 3999, inclusive. See Also ROMAN: Formats a number in Roman numerals. Examples
AND function: The AND function returns true if all the provided arguments are logically true, and false if any of the provided arguments are logically false. Sample Usage AND(A2 = “foo”, A3 = “bar”) AND(TRUE,FALSE,TRUE) AND(A1:A10,B1:B10) AND(0,1,2,3) Syntax AND(logical_expression1, [logical_expression2, …]) logical_expression1 – An expression or reference to a cell containing an expression that represents … Read more
IFERROR Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. Examples Note: Each example is in its own tab. Sample Usage IFERROR(A1,”Error in cell A1″) IFERROR(A2) General usage Returns a blank if the test is an error … Read more
ISDATE function: ISDATE function returns whether a value is a date. Parts of an ISDATE function ISDATE(value) Part Description value The value to be verified as a date. Sample formulas ISDATE(“July 20”) ISDATE(A1)ISDATE(“7/20/1969”) Notes Ensure your date has quotation marks around it unless it’s a reference to a cell. Examples A B 1 Formula Result … Read more
NORMINV Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation. Sample Usage NORMINV(.75,1,4) NORMINV(A2,A3,A4) Syntax NORMINV(x, mean, standard_deviation) x – The input to the normal distribution function. mean – The mean (mu) of the normal distribution function. standard_deviation – The standard deviation (sigma) of the normal distribution … Read more
When you use Google Sheets on a daily basis, you might end up in need of use Google sheets conditional formatting based on another cell. Here I collected some examples for conditional formatting based on another cell, this will make it more clear for you, and hopefully it will be useful for your needs. … Read more
Creating a histogram in Google Sheets is easy and fun, let’s start What is Histogram? A histogram is a graphical display of data using bars of different heights. In a histogram, each bar groups numbers into ranges. Taller bars show that more data falls in that range. A histogram displays the shape and spread of … Read more
Frequencies tell us how often different values occur in a dataset, therefore we can easily calculate frequencies in Google Sheets by using the FREQUENCY() function. FREQUENCY in Google sheets Calculates the frequency distribution of a one-column array into specified classes. Sample Usage FREQUENCY(A2:A40,B2:B5) Syntax FREQUENCY(data, classes) data – The array or range containing the values to … Read more
Google Sheets Day of Week is easy to find with WEEKDAY function. The WEEKDAY function accepts a date and returns the day number of that date. The date must be in a valid format, so you have to use the DATE function, wrap it in quotes, or use a cell reference to a cell containing a date. … Read more