I need to validate with a formula
 

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

I need to validate with a formula
 

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

I need to validate with a formula
 

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


.

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


.