IF Function.
 

Is there a way that if the value in the IF function is false to prompt me for
a value to enter??

IF Function.
 

=IF(1=2,"ok","Enter valid value")

If this post helps click Yes
---------------
Jacob Skaria


"GEM" wrote:

Is there a way that if the value in the IF function is false to prompt me for
a value to enter??

IF Function.
 

What is 1=2?? Should'nt you make reference to a cell on the logical test??

"Jacob Skaria" wrote:

=IF(1=2,"ok","Enter valid value")

If this post helps click Yes
---------------
Jacob Skaria


"GEM" wrote:

Is there a way that if the value in the IF function is false to prompt me for
a value to enter??

IF Function.
 

Not without a macro.

If you want a macro solution, post to the .programming group. If you do,
you'll need to provide more detail.

Regards,
Fred.

"GEM" wrote in message
...
Is there a way that if the value in the IF function is false to prompt me
for
a value to enter??