multiple arguments in one formula

**bobbieexcel** · Apr 18th, 2002, 04:40 PM

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 ]

**John McGraw** · Apr 18th, 2002, 04:52 PM

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 ]