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.
Click the first empty cell where the result will be shown.
4.
Click Functions icon and select More functions…
5.
In new window clik Narrow by and select Logical.
6.
Search for IF function to see the Syntax.
7.
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.
8.
Select the function you want and click on the cell that represents working hours for Matthew…
9.
…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”.
10.
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…
11.
…...and drag the mouse down to the Luke.
The table will automatically refresh function for all employees.
In the chosen cell, type the equal sign and the beginning of the syntax. A box with the name and syntax of the formula you're creating will appear when auto-suggest is activated. Check: https://propainterswhangarei.co.nz/