IF Function.

  • Thread starter Thread starter GEM
  • Start date Start date
G

GEM

Is there a way that if the value in the IF function is false to prompt me for
a value to enter??
 
=IF(1=2,"ok","Enter valid value")

If this post helps click Yes
 
What is 1=2?? Should'nt you make reference to a cell on the logical test??
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - IF Functions 1
IF function 3
Combining Functions 3
Excel code, end function? 0
end zero in a cell 3
Function can not read cell value properly without enter 2
Using IF function for multiples of a trigger 2
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1

Back
Top