• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Checking Data Entry

Whether you enter data in a database form or make entries directly into the cells of a worksheet, you can prevent accidental errors by using formulas that automatically cross-check data as you enter it. Figure 25.2 shows an example of a data-entry form that uses formulas to cross-check entered data. The formula bar shows the formula used to check the data in cell D4. This formula produces no result, "", if the date entered in D4 is after 1/1/1996. However, if the date entered is prior to 1/1/1996, then the message appears in the formula's cell.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint