Learn how to use IF & nested IF statement in Google Sheets. & highlight a row using conditional formatting, set up multiple conditional formatting rules.

The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types ...

Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, ...

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce 'if' statements and learn how to ...

With new support for named functions, LAMBDA and helper functions, spreadsheet calculations — especially with arrays — may be more efficient and elegant.