If your answer will be inserted in A1, then in B1 enter the following:

=IF(A1="","",IF(A1="Batman","Which Batman",IF(A1="Batman
Forever","Correct","Incorrect")))

"movie guess" wrote:

Im a very rookie..
i want to make a quiz using excel 2003..

ex.. i insert batman forever poster.jpg on it
then i put a question below..
"what movie this is?"
if you write down "batman" i want the cell appear " which batman ?"
but if you filled with "batman forever" it will appears " correct "
thank you..


i have try using "function with =IF function..but that is only true or
false statement
and can't show "which batman?"
or is it possible to merge to formulas in one cell

thank you..and thank you