Help on Data Validation
Dear solver,
I have prepared a receipt form in excel.
In cell J7, I have a drop down containing options "Cash, Cheque, Demand Draft, Payorder, Credit Card, Debit Card".
What I want, if a user selects "Cheque or Demand Draft or Payorder" then Cell no.
D3 should accept numeric value upto maximum of 6 digit.
In other word, he/she could enter the instrument number of "Cheque or Demand Draft or Payorder".
If he/she selects "Cash,
Credit Card, Debit Card" then he could not enter anything, means D3 should be locked.
If he/she tries do the same, an error msg should come, as it comes in Data Validation.
Pls help.
Many thanks.
Ayushman
Keys to the Problem Help on Data Validation
Download Error Fixer for Free Now
Choose Custom in the Allow box and use the following as the FORMULA;
=AND(D3=int(D3),OR(J7="Cheque",J7="Demand Draft",J7="Pay Order"),D3>0,D3<1000000)
If you want to allow the decimals then delete the D3=INT(D3) part ...
also delete the comma
If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.
Recommended Method to Repair the Problem: Help on Data Validation:
How to Fix Help on Data Validation with SmartPCFixer?
1. Download Error Fixer. Install it on your system.
2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.
Related: Store not opening in Windows 8 1 pro the procedure entry point prop mgr client lookup pro could not be located bin link dynamic link library OLEACC dll System Restore did not complete sucessfully error code 0x80070057 the ordinal 3 could not be located in the dynamic link library wnaspi32 dll the following formula does not work in excel 97 2003 COUNTIFS Activity G3 G80 61 Activity G3 G80 90 please help The display format of my web browser will not show images tooolbar at top on my computer explorer or any other explorer except on IE is not visible and Winows dosent run in safe mode at all When ever i try to install itunes 64 bit my computer says The windows installer service could not be accessed This can occur if you are running windows in safe mode UNABLE TO ACCESS THE IE8 HOME PAGE AS AND WHEN I TRY OPENING IT I GET THE MESSAGE NOT RESPONDING PLEASE HELP User having sudden java issue in IE 6 on web site that has previously worked and that has not changed Unable to set the current location for the recovery image The recovery image cannot be written Error Code 0x80004005 Used to be able to send pictures on Outlook Express 6 0 Now my friends cannot open the files I send to them Website amantexintel com will not display in Internet Explorer 8 why System not working properly after uninstalling pc cleaner 2013 program Wheel spinning and Not Responding Unable to ping a website in command prompt with an error message ping is not recognized as an internal or external command,After installing Windows 7 Service Pack 1 my internet connection speed has dropped considerably sony vaio drivers Error Code 0x81000006 cannot find backup device in Windows 7 computer sony drivers Is there an option for Windows 7 to shut down automatically after installing updates VAIO Driver Download Resetting Windows 8 did not install a clean copy of windows Your PC ran into a trouble sony drivers Starting display problem Your computer did not shut down properly Windows is collecting information sony drivers Windows 8 1 Low Memory Frequent Warnings sony drivers Windows 7 with 64 bit OS ignores most formatting CSS commands sony dvd drivers Intel Rapid Storage Technology driver DOWNLOAD
Read More: Corel Draw 5 will not load on my Win 7 laptop. Works fine on XP laptop.,Double Clicking on Pivot Data,Error activating ICS on vista home basic. Error: 0x800702FD,Control which window changes focus to target of hyperlink?,I need to create a formula that will generate a random alphanumeric output always 7 characters,Does shutting down my laptop affects the backend upgradation process from Win 8 to Win 8.1?
没有评论:
发表评论
注意:只有此博客的成员才能发布评论。