An If/Than function

[avmaas]

Im looking to build a data base that totals check list complete items, there are eight steps to complete. Whan all eight are complete the total should be 100%. Now i also want to have within the steps of each check list item if the step was unsatisfactory, marginal and compliant. Where unsatisfactory has no value towards completion, marginal only counts for 1/2 credit for completing the step and Compliant get full credit. Can anyone help me with a function for this?

Thank you.

[Kaper]

from forum rules:

Want to get your question answered quickly?
Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[Kaper]

PS. Of course in case of Access last paragraph shall read" "Post a sample database. ..." ;-)