Forum Discussion
Trivia Score Sheet
What I'm trying to accomplish is having the letter w to represent a word, but also having a numerical value with it like 6w But here is the tricky part of it, I need to have that numerical ...
wyoung1969 , thank you.
It's unclear what to do if you have any other text after the number except w. Like in case of 1(1). If ignore as in the sample
formula could be
=SUMPRODUCT(1*IFERROR(SUBSTITUTE(LOWER(C4:E4),"w","")+0,0))You may also highlight cells with w by conditional formatting rule with formula
=RIGHT(C4)="w"
SergeiBaklan The 1(1) you refer to is in when they bid the points but don't get the answer correct.
The only time that the W would be used is when they don't know the answer and they want free points for that question.