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 ...
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
Sorry, can't help with Google Sheets, have no idea where it could be the difference.