More than 7 IF statements

[NoiCe]

Hello Again,

My second question is that I know you can use a VLookup function to bypass the limitation on the 7 If statements but here is what I am trying to do:

• If K1 = A and M1=1 then I want to perform a calculation in another cell let's just say J1: Roundup((N7/2),0)

• If K1 = A and M1=2 then J1=Roundup((N7/2)*2,0)

• If K1 = B and M1=1 then J1= a different calculation

I have about 8-10 if statements that need to do a special calculation. Now I tried creating a seperate sheet and place the individual calculations in there but it doesn't seem to work. Can anyone help me out?

[deadlyduck]

You can combine if statements by using the addition symbol.

The following (nonsensical) example in which the value of a number in cell A1 is evaluated shows the idea:

Please Login or Register  to view this content.

You'll see that there are 8 IF statements in this piece of code but the last of them is included by using the + symbol.

[VBA Noob]

Link may be of interest

http://www.excelforum.com/showpost.p...18&postcount=5

VBA Noob

[oldchippy]

And this one, may be?

http://www.excelforum.com/showthread.php?p=1781039

[NoiCe]

I think these sites will help me in what I need to do...

Thank you all for your help!