I have a score card with a computed percentage grade (e.g., 84) that I want to turn into an easy letter grade for my stakeholders.Rather than using a huge nested IF formula I thought I'd try to use SWITCH to compare and create some values.SWITCH( {%...
Hi,We have a scoring system that rates functionality in an interface. So as not to bias the total score, if the functionality isn't present we ask evaluators to give it a -1.In Excel, the final score is determined by a formula that:Counts the number ...
I'm having a similar issue with scoring a single piece of content across multiple criteria and categories.Our scores must be imported from excel because we can't use the AT forms (not flexible enough).With this situation, could I look up the score fo...
Hum...it's a good start and not working exactly the way I need. Formula in the Max Possible Score: VTG field is: IF({5.1 Content uses voice principles appropriate for the audience}, 3) +IF({5.2 Content uses a tone that matches the user's situation}, ...
