IF Function.

[GEM]

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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[GEM]

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

 

[Fred Smith]

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.