Multiple logic - If/OR

[tigerstew]

Can someone help me with the formula the following please with the SUM Logic function;

I am trying to put prices in - so if they select (for example) apple, banana or orange from a drop down list, the price will be $1, but if they select anything else, the price will be $1.15

So, is there an "or" function? I cant seem to make AND work...

=IF(A1="apple" OR "Banana" OR "Orange",1*A2,1.15*A2)

 

[mikerickson]

The syntax for OR would be

=IF(OR(A1="Apple",A1="Banana",A1="Orange"), 1*A2, 1.15*A2)

although I prefer the formulation

=A2 * IF(OR(A1="Apple",A1="Banana",A1="Orange"), 1, 1.15)

 

[T. Valko]

Can someone help me with the formula the following please with the SUM Logic function;

I am trying to put prices in - so if they select (for example) apple, banana or orange from a drop down list, the price will be $1, but if they select anything else, the price will be $1.15

So, is there an "or" function? I cant seem to make AND work...

=IF(A1="apple" OR "Banana" OR "Orange",1*A2,1.15*A2)

Here's another one...

=IF(OR(A1={"Apple","Banana","Orange"}),1*A2,1.15*A2)