Forum Discussion
Solved
Combining IFS(SEARCH
I have a student quiz. I'm parsing a phrase to see if the student answered "survey" (case insensitive). I'm assigning 1 point for a correct answer .8 for the spelling survay .5 for servay Else 0 ...
SergeiBaklanI have an answer "Servay " that got evaluated as 0.
What's wrong?
=SUM(COUNTIF(F2,"*"&{"survey","survay","servay"} &"*")*{1,0.8,0.5})
It works
If you are on Excel which doesn't support dynamic arrays try to use SUMPRODUCT() instead of SUM(). Please check the file attached.
- Very possible. I was using Google sheets. I'll go through it again. Thanks
- Thanks for this
