|My apologies - I am new to the Excel and fomatting world. I'll try to explain what I need again.|
In P4 (total number of deducted points I am using the IF(ISBLANK formula to get the total number of points being deducted from each work item with the maximum achievable points of 100 (the # of errors is listed in N4). 100 * 30 (ie 2 errors, deduct 30 points each). If the final score (once 60 points is deducted from 100) if the score is 100 or a negative value (ie -20) then the work item will score 0 points (hence the "0") this is necessary to get the average of all approved work item for monthend. Also if there is no errors in one particular catergory the cell should remain blank.
Once Excel has calulated P4*30 and the other two categoris (errors are based on severity) the other two results (final score) can be found in cells T3 and X3 (all three are P3, T3,X3)
Now in cell AF4 I am adding the final scores for all three categories (P3, T3,X3) to be subtracted from 100. (ie 100-SUM(P3+ T3+X3)=60
However I am running into the #Name error because the 0 in the IF(ISBLANK formula is being read as text.
I hope this clears up your question - I appreciate any help I can get. Thanks!