Whether information in a list is being analyzed or information is being entered by a user, providing messages dependant on the information becomes extremely useful.
In this recipe, you will learn to use IF statements to provide messages to users depending on presented information. This recipe will utilize a worksheet with three input fields. When a field entry is below a set threshold, conditional messages will warn the user that the field value must be greater.
To begin, we will create an entry message for Input 1:
1. Select cell E2 and enter the formula =IF(C2<2,"Input cannot be less than 2%",""), and press enter.
2. Upon pressing Enter, the cell will appear blank; select View from the Excel toolbar:
Within the Show/Hide options, there are several checkboxes. These checkboxes will affect the way Excel displays information.
3. Because this worksheet is to become a user input form, we will remove the checkmarks within the boxes for...