Validating if a certain text and greater than or equal to a value..

[maplenet2]

So I am creating a form to calculate pay for a certain classification and I want a certain cell to be equal to or greater than a value, whereas the value is determined by another cell. For instance, if you select one of the classifications and that classification has a minimum pay of 1500, the value should be greater than or equal to the minimum.

Here is an example: In cell C4, I click on the list and select Class 1. Now Class 1 has a minimum pay of 1000 and I am required to put a start pay amount in cell D4. I input the value 950 and get an error. Therefore I change it to 1050 to meet the cell requirements.

Thanks in advance.

[shukla.ankur281190]

Hi Welcome to Forum ,

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[FDibbins]

Hi, welcome to the forum

Agree that seeing a sample file will help,having said that though, if you have a list of classes with the minimum amount, something like this should work...
1. Data tab/Data validation
2. Allow = Custom
3. =D4>=vlookup(C4,range-with-classes,1,0)