How to use IF function in Google Drive Spreadsheet

I'll show you the basic usage of IF function in Google Drive Spreadsheet. The IF function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

Open new or existing Spreadsheet in Google Drive.

Enter any data. You can also copy mine data.

Click the first empty cell where the result will be shown.

Click Functions icon and select More functions…

In new window clik Narrow by and select Logical.

Search for IF function to see the Syntax.

Now type an equal sign and start of the syntax in selected cell. Auto-suggest will show a box displaying the name and syntax of the formula you're building.

Select the function you want and click on the cell that represents working hours for Matthew…

…and write  >100;”Yes”;”No” (see the picture). Press ENTER. Number 100 represents number of working hours.

Everything over 100 will return “Yes”, everything under 100 will return “No”.

Calculation for Matthew is that he didn’t have more than 100 hours.

Now select the cell where you inserted IF function. Go with the mouse to the bottom right edge of the cell and hold the mouse button…

…...and drag the mouse down to the Luke.

The table will automatically refresh function for all employees.

Also recommended

  How to count an average in Google spreadsheet