Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

Basic Excel Formula Help

EncEnc A Fool with CompassionPronouns: He, Him, HisRegistered User regular
edited September 2013 in Help / Advice Forum
I'm working on an assessment grading system for one of our programs we offer. Our test collection system (which is atrocious) gets us data back in flights of three in an excel document:

[ A ] [ B ] [ C ]
27 6 2

With column A being correct answers, B being incorrect answers, and C being "no response"

I need to know how to write, in excel, this formula: [1A / (1A+1B)]= for Column D

I have no idea how to write excel formulas and I feel terrible for asking. Apologies for the dumb question!

Enc on

Posts

  • ThunderSaidThunderSaid Registered User regular
    The syntax should just be:

    =(A1/(A1+B1))

  • DeebaserDeebaser on my way to work in a suit and a tie Ahhhh...come on fucking guyRegistered User regular
    so close... so very close


    =A1/(A1+B1)

    Copy that down the column

  • EncEnc A Fool with Compassion Pronouns: He, Him, HisRegistered User regular
    Perfect, thanks.

  • DeebaserDeebaser on my way to work in a suit and a tie Ahhhh...come on fucking guyRegistered User regular
    Oh and don't feel bad. Some of us LOVE answering excel questions, even silly basic ones. Hell, ESPECIALLY silly basic ones. It make me feel like I have some job security! :)

Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum