I dont think you want AND logic, you want OR logic. You need to nest a if statement: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?

=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 ]

## Like this thread? Share it with others