June 14, 2021

## LOOKUP function in Google Sheet

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 …

## IF function in Google Sheet

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 …

## MIN function in Google Sheet

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 …

## MAX function in Google Sheet

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 …

## ISBLANK function in Google Sheet

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 …

## FILTER function in Google Sheet

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 …

## FLOOR function in Google Sheet

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 …

## CEILING function in Google Sheet

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 …

## MROUND function in Google Sheet

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 …

## INDIRECT function in Google Sheet

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