"If" and "or" function

plumstone · Oct 14, 2004

If A2=100, or 200 or 300 or 400 or 500 or 820, Then let C2=B2*2
How can I write this formula?
Thanks.

Frank Kabel · Oct 14, 2004

Hi
in C2 enter
=IF(OR(A2={100,200,300,400,500,820}),B2*2,"not defined")

Trevor Shuttleworth · Oct 14, 2004

One way:

in cell C2:

=IF(OR(A2=100,A2=200,A2=300,A2=400,A2=500,A2=820),B2*2,"")

Regards

Trevor