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

A Fool with CompassionThe Land of Flowers (and Dragons)Registered User regular
edited September 2013
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

• Registered User regular
The syntax should just be:

=(A1/(A1+B1))

• 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.
• 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/
• 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.