1. Registered User
Join Date
Dec 2003
Posts
138

I'm trying to set up a true/false test scoring sheet in excel.
here are my criteria:

if the condition met is true then add 1 to this category
if it is false then add 1 to a different category

how would I enter this?

2. Registered User
Join Date
Mar 2004
Location
Minnesota, USA, Earth
Posts
65

Hi,

If I understand your question. It sounds like you're going to need two different IF statements, one in each catagory, but they can be nearly identical to each other.

For Catagory A
=IF(condition=True,1,0)
For Catagory B
=If(condition=true,0,1)

I would guess that you're trying to count the number in each catagory. If so, you can use either COUNT or COUNTIF statement.

Hope this helps,
Mike

3. Registered User
Join Date
Nov 2002
Location
Oakland, CA
Posts
126
Why so complicated?...

if(condition, CategoryA + 1, CategoryB +1)

CategoryA+1 is the true statement
I bet you know now what CategoryB+1 is

4. Registered User
Join Date
Dec 2003
Posts
138
Thanks, I figured it out earlier. Thanks a lot anyway.

Dendalee

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•