(Solved) : Created Google Form Evaluate Team Members Based Certain Questions Question Weightage Googl Q30756897 . . . .

I created a google form to evaluate team members based oncertain questions. Each question has its own weightage. A googlesheet was created to recond the responses. I have created a formulafor the total, percentage, etc. I want to create a formula in orderto automatically deduct marks from the total when I choose “N/A”instead of allloting any marks.(for example if the total evaluationis from 50 and I choose “N/A” for a question of 4 marks then those4 marks will be automatically deducted from the total value. Thismakes the evaluation from 46 instead of 50).

Expert Answer

An answer will be