Additional Information
| Time | 60 mins |
|---|
If Statements
$126.00
Use the IF logical function to test your data and calculate a value or display a word or phrase based on whether the logical test is true or false. You can use the IF function along with the AND and OR functions.
Related Products
-
“Cut” will remove a selection of data and give you the possiblity to paste it elsewhere in your spreadsheet. It’s basically a move command. “Copy” will duplicate a selected range of data. “Paste” will place any selected data that is copied or cut into the current selected cell. There are multiple ways to execute these commands.
-
Data validation rules control what type of data an end user can enter into selected cells. Such valid data can be of a specific text length, particular dates, or whole numbers. You can also create your own drop down list of choices. This feature helps maintain the integrity of the data populating your database.
Reviews
There are no reviews yet.