if with 2 conditions

[maxx]

hi guys (nd gals too),


i need a simple formula which can check for 2 conditions. something like


IF a>2 AND b<3 then a+b, else a+c.


tried going through the help file, but couldn't find anything useful.


with thnx and regards

 

[Hui]

=If(and(a>2, b<3), a+b, a+c)

Where a, b & c are cell references or named ranges

 

[ahhhmed]

Hi,

How can we perform coditionals conditionally?

ie, in A2 there is a dropdown list with 4 choices one is empty.

in A3, I want to perform certain conditions one for each choice in A2.

How can this be done?

 

[maxx]

wow, thnx Hui.

thnx for the prompt reply bud.

 

[Hui]

@Ahhhmed

You should really start a new post for this as it isn't related to the original post.


If the values in A2 are 1 to 4 you can use a Choose Function

=Choose(A2, Option 1, Option 2, Option 3, Option 4)


If the values in A4 are not 1 to 4

=If(A2=Value 1, Option 1, if(A2=Value 2, Option 2, if(A2=Value 3, Option 3, Option 4)))