G Guest Oct 14, 2004 #1 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.
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.
F Frank Kabel Oct 14, 2004 #2 Hi in C2 enter =IF(OR(A2={100,200,300,400,500,820}),B2*2,"not defined")
T Trevor Shuttleworth Oct 14, 2004 #3 One way: in cell C2: =IF(OR(A2=100,A2=200,A2=300,A2=400,A2=500,A2=820),B2*2,"") Regards Trevor
