Tally adjusted based on N/A responses

[richardrns]

Hello All,

Disclaimer, my Excel skills are a bit limited, but I do need help creating a formula. I am trying to tweak a QA scorecard. Each line item has been given a designated weighting. For example, the first line item is worth 2 marks. To achieve these 2 marks, a rep needs to do two things correctly. However, each of these two things can be scored Yes, No, or N/A. I would like to know if it is possible to create a formula whereby the cell for the designated weighting will only lower based on how many N/A's are counted in the two subsequent cells. So if cell A1 = 2 (designated weight), cell B1 = Yes, and cell C1= N/A, then I would like to know what formula can be used so that cell A1 reduces from 2 to 1, as a result of the N/A in cell C1. Hope this makes sense!

Any help that can be offered is greatly appreciated. Thanks in advance.

 

[mart37]

Sorry you can't change the value of an other cell. You have to use a second column for calculate the real weight,

 

[richardrns]

Sorry you can't change the value of an other cell. You have to use a second column for calculate the real weight,

Appreciate the feedback - good to know.

 

[Herakles]

First of all, may I assume that the N/A is an error and needs to be corrected.

What is the formula in C1 if there is one? If it is not an error then it's not good practice to use N/A as meaning 'Not Applicable.'

You can get it to work if the Weight in A1 is a result of a formula. Is this or could this be the case?