Club PA 2.0 has arrived! If you'd like to access some extra PA content and help support the forums, check it out at patreon.com/ClubPA
The image size limit has been raised to 1mb! Anything larger than that should be linked to. This is a HARD limit, please do not abuse it.
Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

Basic Excel Formula Help

EncEnc A Fool with CompassionThe Land of Flowers (and Dragons)Registered 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!

Guns make you stupid. Better to fight your wars with duct tape. Duct tape makes you smart.

I make Encounter Maps for Pathfinder and D&D! Check them out here: https://falleron.com/
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

    YOLO. Swag. Whatever. Fuck it. Lets do this.
  • EncEnc A Fool with Compassion The Land of Flowers (and Dragons)Registered User regular
    Perfect, thanks.

    Guns make you stupid. Better to fight your wars with duct tape. Duct tape makes you smart.

    I make Encounter Maps for Pathfinder and D&D! Check them out here: https://falleron.com/
  • 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! :)

    YOLO. Swag. Whatever. Fuck it. Lets do this.
    pirateluigiEncLaOsmysticjuicerMaguano
Sign In or Register to comment.