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?

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

Why so complicated?...

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

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

Thanks, I figured it out earlier. Thanks a lot anyway.

Dendalee