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 …
Tech Tips & Tricks
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 …