Hello, it's yet another question with the IF function and the drop-down list. I know there are numerous threads already about it, but I can't use the INDIRECT function in my context.
In short, my excel program asks the user to input some numbers.
Example:
What is your age : [ B3 ]
What age did you graduate : [ B4 ]
=IF(B4<B3,"show the drop-down list but I dont know how", "Impossible")
Basically, if the logical test is true, I want to show a drop-down list.
If it's false, I want it to show impossible.
Thank you for the help... I can provide more information if it wasn't clear!
Bookmarks