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})

HansVogelaar

MVP

Feb 21, 2021

jtjohnston_quebec

=IFS(ISNUMBER(SEARCH("survey",F2)),1,ISNUMBER(SEARCH("survay",F2)),0.8,ISNUMBER(SEARCH("servay",F2)),0.5,TRUE,0)

jtjohnston_quebec
Copper Contributor
Feb 22, 2021
HansVogelaarwhy did you use isnumber. why check to see if it is a number?
jtjohnston_quebec
Copper Contributor
Feb 21, 2021
Thanks
.
Why isnumber?