Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: multiple arguments in one formula

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi. I need to know how do I make this formula work: I want to say If(A1=4,5)If(A7=3,4)If(A7=2,3)If(A7=1,2). What I am trying to accomplish is to state in A1 what a level is, then state in A3 the value that i specify in that formula. So I went to A3 and tried that forumula, and it only works if I only have one argument. It will let me say IF(a1=4,5), but there will be levels 1 - 4 in column A, so depending on what level I enter, I need column C to give me a point value of 2 - 5. How do I tell a cell to do this?

    [ This Message was edited by: bobbieexcel on 2002-04-18 15:57 ]

    [ This Message was edited by: bobbieexcel on 2002-04-18 15:58 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 15:40, bobbieexcel wrote:
    I need a formula. I want to enter levels in A1:A4. A1 is 4, A2 is 3, etc. I also want to have column C give me a number depending on the level in A1:A4. If A1=4, then I want C1=7. If A1=3, then I want C1=6. I did the if,and,choose,or functions, and they all allow one. What i want to do is say if(A1=4,7) and (A1=3,6)and (A1=2,5)but it says my formula is not correct. How do i put in a formula with ands and ifs?
    I dont think you want AND logic, you want OR logic. You need to nest a if statement:
    =IF(A1=4,7,IF(A1=3,6,IF(A1=2,5)))

    That should give the right answer for each situation.

    To explain the above: (I know that formula may be hard to read)

    The IF function is like this:
    IF(CONDITION,VALUE IF TRUE, VALUE IF FALSE)

    So if a=1 is true, you give a 7... But if a1=1 is false, you test for the next value (a1=3) if that is true you give a 6... If it is false you can test for the next value. You can do this as many times as you want. Just be careful with the parenthesis.

    [ This Message was edited by: John McGraw on 2002-04-18 15:55 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Macon, Georgia USA
    Posts
    158
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use the following type of statement
    =if(a1=1,2,if(a2=2,3,if(a3=3,4)))

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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