bobbieexcel
New Member
- Joined
- Apr 17, 2002
- Messages
- 35
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
This message was edited by bobbieexcel on 2002-04-18 15:57
This message was edited by bobbieexcel on 2002-04-18 15:58