How to Use Data Validation When Creating a Budget
I created this tutorial in response to a question from one of my viewers. He wanted to know what formula to use to prevent an end user from entering a Budget Number or Budget Percentage that would exceed the limit set for his budget,
Well, in my response, I show him how to create this formula - but - in the context of Data Validation. When you create a formula in Data Validation, the answer to the Formula must return TRUE. This means that the entry is OK. If the answer to the Data Validation Formula is FALSE, then this entry violates the rule and an Error Message Box appears.
In this tutorial, I demonstrate two approaches to creating a budget. First, by entering a Constant Value. Then, by entering a Percentage of Budget.
I invite you to visit my secure, online shopping website - http://shop.thecompanyrocks.com - to learn about all of the training resources that I offer.
Danny Rocks
The Company Rocks
Watch video How to Use Data Validation When Creating a Budget online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 03 November 2012, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,939 once and liked it 28 people.