It is normally used to create forms for others to fill.

It can be used to ensure that the user enters correct value.

If wrong value entered by user,then it can show error or warning message


Question 1

Prepare Interest Calculator in following format


  Use of Data Validation to make forms - Data Validation


User has to fill just white colored cells,it should automatically calculate Interest

Download and try 



Prepare Interest Calculator in following format





  1. Excel

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 10 years. He also provides Accounts Tax GST Training in Delhi and Pune.