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