WHAT FUNCTION SHOULD I USE?
 

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

WHAT FUNCTION SHOULD I USE?
 

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