formula for calcuation of weighted percentages on scorecard.

D

dtoney

I need a formula for calculating weighted percentages of accuracy for
scorecards. Certain sections are scored at a lower percentage of weight than
others and there are three sections of 100% on each scorecard. Based on any
total score lower than 97%, I need to return "Failed" into a text box. The
current databases already in place use multiple queries that are so hard to
follow, I'd really like to clean up a bit. Any suggestions are greatly
appreciated!

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top