Forum Discussion
If formula problem
Hi all! I am new to using excel so I appreciate your help in advance :) I created a spreadsheet to track multiple choice answers for a quiz. This is the formula to track if people got the answer righ...
As variant
=IF(F3 = "a", 1,
IF( SUM( --ISNUMBER( SEARCH( {"b","c","d","-"}, F3) ) ), 0, "NA"
))