|
|
|||
Custom Validation in Excel |
|||
|
Our video today shows how to use a custom
validation in Excel which relates to budgeting. We wish that the sum of
'advertising', 'phone' and 'rent' expenses should not exceed 5000 and
as soon as that happens the data entry operator or user should be
warned and take necessary action. |
|||
|
How to implement custom validation
in Excel:
The sum function prevents the budget Excel range from exceeding a certain total and the trim text function doesn't allow the user to add names with leading or trailing spaces. |
|||
|
|
|||
|
|||