Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Web services | Google Drive | How to use IF function in Google Drive Spreadsheet
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

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.

 
  Author: Brodjan | Version: | 11th November 2013 |  
 
 
1.
 

Open new or existing Spreadsheet in Google Drive.

 
 
2.
 

Enter any data. You can also copy mine data.

 
 
3.
 

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.

Also recommended

 
 
 
   
  Please login to post a comment
  Click to open user profile  
pinaagaion, 29th Nov 2024, 4:00 PM
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/
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO