if and OR

[rami79]

Hello Guys,

Please i need your help.
What i need to do is the following:

If cell A1=1, i want the sum of cell B1+B2 or if cell A1=2 i need (B1+B2)*2.

Thank you

Rami

 

[PA HS Teacher]

=If(A1=1,B1+B2,If(A1=2,(B1+B2)*2,""))

If A1 is always 1 or 2, you could use:

=Choose(A1,B1+B2,(B1+B2)*2)

or you could use

=(A1+B2)*(1+(A1>1))

 

[rami79]

great! Thank you