Using Data Validation to Force a Decimalized Numeric Entry
Data Validation is an excellent way to control data entry to meet a certain condition.
Suppose you want to insure that numbers entered in the yellow cells are OK for decimals, AND that only numeric increments of a quarter of a number are allowed. For example, the entry of 6.75 or 3.25 are allowed, but 4.35 or 1.62 are not allowed.
The following steps show how this can be done.
Step 3 of 5
In the Data Validation dialog box:
• Click onto the Settings tab.
• Click the down arrow for the Allow field.
• In the list of allowable categories, select Custom.
![SettingsTab_Allow_Custom](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vLR8VPKwANOZnVhuF93OTn7lTWr0eoGD8ksrwxaPuw8n46VRURiHKxpYsXOPNhrnc_597nA-jLKi2DZnh7bRHzS9m21Zt5Ch80HaYw9z-sZYV-jXotB2oXSRHacgeRPwgVwF3Tv0vjYdEBCtlwOHfN=s0-d)
In the Data Validation dialog box:
• Click onto the Settings tab.
• Click the down arrow for the Allow field.
• In the list of allowable categories, select Custom.
Step 4 of 5
In the Formula field, enter the formula that is relative to your selected range.
In this example, that formula would be
![DataValidationFormula](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_t8JgpWxBwDGv8nRpMjIfXWullayJr4w6dNUA1oRDTgfHJkTN1A1OCScDaPaWYh_YxZoqT-b9OJ9JjCx62J0o0XnbuDPv8PDoOD80bd8nP2EcRzpJ4obENRom9Puqc2eL6wLy02WCVB5fwYminMppc=s0-d)
In the Formula field, enter the formula that is relative to your selected range.
In this example, that formula would be
=MOD(D5,0.25)=0
Step 5 of 5
Still in the Data Validation dialog box:
• Click the Error Alert tab.
• Click to enter a checkmark in the box next to “Show error alert after invalid data is entered.”
• In the Style field, from the drop down list, select Stop.
• Enter the text for the Title of the error message you want to convey.
• Enter the text for the error message you want to convey.
• Click the OK button.
![DataValidation_ErrorAlert](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sUSpAqJlAxyLOKDRabmJfw-0wf8yze54ZiulUkVkXu_lpwWmv-K8l9LRuo16LrWwH2mHRTJyU9Nxjr68kgzFaX8-tf5xi7CbbU1Fc3EfAMQufqcEphxXu2Xi_-lBxX9GxlNrCbmvczrSi8ARQCauOXOw=s0-d)
#evba #etipfree #kingexcelStill in the Data Validation dialog box:
• Click the Error Alert tab.
• Click to enter a checkmark in the box next to “Show error alert after invalid data is entered.”
• In the Style field, from the drop down list, select Stop.
• Enter the text for the Title of the error message you want to convey.
• Enter the text for the error message you want to convey.
• Click the OK button.
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
No comments:
Post a Comment