I am trying to set up a data validation rule for a particular cell on an excell spreadsheet. The rule I'm trying to implement is not allowing a number to be entered that is less than the value that is in cell I4. However every time I type this in the data validation condition box I get an error "The minimun must be a numeruc value, numeric expression, or refer to a cell containing a numeric value." Can anyone help me? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
EXCEL DATA VALIDATION
- Thread starter wcj00
- Start date
Set the data validation to custom and enter the following into the reference field:
=AND(ISNUMBER(A1),A1>I4)
Assuming that A1 is the cell containing the validation.
But, data validation doesn't work directly with numeric expressions or cell references.
For example, if you were to enter a formula into the cell (A1) with the above validation rule and but the formula returns a value greater than the value in I4, the data validation will allow it.
If this is what you want to do though, there are possibilities using data validation that might work. Explain which formulae you wish to use, and we can help you through setting it up.
If you are willing, you could use VBA code. ;-)
Let me know what you think!
Peace!![[peace]](/data/assets/smilies/peace.gif "[peace] [peace]")
Mike
Never say Never!!!
Nothing is impossible!!!
=AND(ISNUMBER(A1),A1>I4)
Assuming that A1 is the cell containing the validation.
But, data validation doesn't work directly with numeric expressions or cell references.
For example, if you were to enter a formula into the cell (A1) with the above validation rule and but the formula returns a value greater than the value in I4, the data validation will allow it.
If this is what you want to do though, there are possibilities using data validation that might work. Explain which formulae you wish to use, and we can help you through setting it up.
If you are willing, you could use VBA code. ;-)
Let me know what you think!
Peace!
Mike
Never say Never!!!
Nothing is impossible!!!
You need the custom validation
enter
=A4>I4
where the cell you are checking is A4 (change to suit)
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
enter
=A4>I4
where the cell you are checking is A4 (change to suit)
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Status