Forum Discussion
logical function
I have tried building a logical function that can help me calculate the exact values in the Score column. This can help me calculate for large data. values under the score section are the criteri...
This work perfectly! I appreciate this very much. My concern is the All answers and count in the K and L cell. is it that anytime in the future I want to build this form I should also do same as in K and L or there is any other way of not referencing K and L but still get the required result?
You can 'hard code' those values into the formula, or you could create a 'name' variable with them instead. Here it is 'hard coded':
=IFERROR(IF(AVERAGE(XLOOKUP(UPPER(B3:G3),{"NO","SOME","A LOT","UNABLE","MISSING"},{0,0,1,1,"M"})),"Yes","No"),"Missing")