Results 1 to 4 of 4

Thread: If Statements

  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Unanswered: If Statements

    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. #2
    Join Date
    Mar 2004
    Location
    Minnesota, USA, Earth
    Posts
    65

    If((I Understand You)=TRUE,Read This,Need More Information)

    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. #3
    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. #4
    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
  •