| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to validate with a formula
< is Not equal
-- Regards, Tom Ogilvy wrote in message ... Thank you very much! that work great. Can you tell me what is the < do, I was using also the formula J18="See Note" but that was not working eather. Kevin -----Original Message----- Perhaps =$J$18<"See Note" This will stop entry when J18 contains See Note (and display the message). When the condition evaluates to True, then the entry is allowed, so you want it to be true when J18 doesn't contain See Note. The comparison alone will return true or false, you don't need the IF statement. -- Regards, Tom Ogilvy "Kevin Brenner" wrote in message ... I need to create a formula to run under Validate, to say something like this: If J18 = "See Note" if TRUE then show message "need more time" if False then the user can type any value(number) and no message box willl appear. I created a IF stament but the message pops up when it's True or False! IF(J18="See Note","","") and Many more variations of this formula. Thanks Kevin Brenner . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to locate and validate specific text from a string | Excel Discussion (Misc queries) | |||
| how do i validate a cell that has a formula | Excel Discussion (Misc queries) | |||
| Validate Entry Custome Formula and Data Names | Excel Worksheet Functions | |||
| Validate a formula NOT a value | Excel Discussion (Misc queries) | |||
| how do I validate the value and not the formula in excel? | Excel Worksheet Functions | |||
Threaded Mode
