Forum Discussion

Copper Contributor

Feb 21, 2021

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 ...

excel

Formulas and Functions

SergeiBaklan
Feb 21, 2021
jtjohnston_quebec

As variant

=SUM(COUNTIF(F2,"*"&{"survey","survay","servay"} &"*")*{1,0.8,0.5})

SergeiBaklan

Diamond Contributor

Feb 21, 2021

jtjohnston_quebec

As variant

=SUM(COUNTIF(F2,"*"&{"survey","survay","servay"} &"*")*{1,0.8,0.5})

jtjohnston_quebec

Copper Contributor

Feb 21, 2021

Thanks for this