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
-
The Autofilter allows you to find, show or hide specific data faster within a database. You can filter data based on two or more criteria by using Excel’s advanced filtering features. Excel provides the Custom AutoFilter and Advanced Filter tools for specifying multiple filtering criteria. Filtering refers to displaying only the information that meets specific criteria.
-
Conditional formatting allows you to quickly highlight important information in a spreadsheet based on your particular criteria. This feature allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. It can also help you represent data in graphical form based on defined values you specify. You can create data bars and icon sets to depict values or divide them into categories. In addition, you can use data bars and icon sets to compare column values to one another. You can also use color scales to format cells differently depending on their values. To boost the performance of the Conditional Formats, you can create your own formula within the Conditional Formatting Rule feature.
Reviews
There are no reviews yet.