Category: Google Sheet Functions

In this lesson we will learn how LOOKUP function works in Google Sheet. The LOOKUP function finds the approximate match of a lookup value in …

In this lesson we will learn how the IF function can be used in Google Sheet. The IF function evaluates a condition and returns respective …

In this lesson we will learn how MIN function works in Google Sheet. The MIN function in Google Sheet is used to find the minimum …

In this lesson we will learn how MAX function works in Google Sheet. The MAX function in Google Sheet is used to find the maximum …

In this lesson we will learn how the ISBLANK function works in Google Sheet. The ISBLANK function is used to check if any cell is …

In this lesson we will learn how the FILTER function works in Google Sheet. The FILTER function is used to get the extract from a …

The FLOOR function in Google Sheet rounds down any specific number to the nearest multiple of any given number. It works similar to the MROUND …

The CEILING function in Google sheet rounds up any specific number to the nearest multiple of any given number. It works similar to the MROUND …

The MROUND function in Google Sheet is used to round a number to it’s nearest specified multiple. =MROUND(number, multiple) Number – This is the number …

The INDIRECT function returns a valid reference  to a cell based on a given text string in both Excel & Google Sheet. INDIRECT function is …