The IF function is extremely useful in transforming your data.
In an IF function, there are several terms, separated by commas. Here is how an IF function is built and how it works:
=IF(THIS SHEET/CELL, IS THIS, THEN DO THIS, IF NOT THEN DO THIS)
Here are a couple of examples to show this.
- What this means is if A1 is greater than 5, then enter the word "Great". If A1 is less than 5, then enter "Bad".
=IF(spreadsheet!A1, "=" "","","Complete")
- The string
"=" ""means "is equal to blank" or "has nothing in it" or "is null". A blank cell is denoted by empty quotes
- What this means is if a A1 is blank, then enter a blank cell. If A1 is not blank, enter "Complete".
Note: Any of the values in the function can be substituted with other functions.
Here's an example:
- What this means is if A1 is "True", then enter the sum of S1 and Z1. If A1 is not "True", then enter "N/A."
Questions? Email us at email@example.com or chat in on the site.