more ifs and an or thrown in for good measure
 

I'm tryng to write a statement for the following:
if a or b are typed in cell than 5 is the multiplier, if c is typed in cell
than 10 is multiplier, if m is typed in cell than 15 is multiplier, anything
else would give an error code. help appreciated. using excel 2000.

=if(or(a1="a",a1="b"),5,if(a1="c",10,if(a1="m",15, "error code")))

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"littlebit" wrote in message
...
I'm tryng to write a statement for the following:
if a or b are typed in cell than 5 is the multiplier, if c is typed in
cell
than 10 is multiplier, if m is typed in cell than 15 is multiplier,
anything
else would give an error code. help appreciated. using excel 2000.

=IF(OR(A2="a",A2="b"),5,IF(A2="c",10,IF(A2="m",15, NA())))

--
HTH

Bob Phillips

"littlebit" wrote in message
...
I'm tryng to write a statement for the following:
if a or b are typed in cell than 5 is the multiplier, if c is typed in
cell
than 10 is multiplier, if m is typed in cell than 15 is multiplier,
anything
else would give an error code. help appreciated. using excel 2000.

One way:

=IF(OR(A1="a",A1="b"),5,IF(A1="c",10,IF(A1="m",15, "Error")))


In article ,
littlebit wrote:

I'm tryng to write a statement for the following:
if a or b are typed in cell than 5 is the multiplier, if c is typed in cell
than 10 is multiplier, if m is typed in cell than 15 is multiplier, anything
else would give an error code. help appreciated. using excel 2000.

"littlebit" wrote:

I'm tryng to write a statement for the following:
if a or b are typed in cell than 5 is the multiplier, if c is typed in cell
than 10 is multiplier, if m is typed in cell than 15 is multiplier, anything
else would give an error code. help appreciated. using excel 2000.

Try

=IF(OR(A2="a",A2="B"),5,IF(A2="c",10,IF(A2="m",15, "Error Value in A2")))

regards
Peter Atherton

And one mo

=IF(OR(A1={"a","b"}),5,IF(A1="c",10,IF(A1="m",15," error")))



littlebit wrote:

I'm tryng to write a statement for the following:
if a or b are typed in cell than 5 is the multiplier, if c is typed in cell
than 10 is multiplier, if m is typed in cell than 15 is multiplier, anything
else would give an error code. help appreciated. using excel 2000.

--

Dave Peterson

Since you asked for an "error code", try this for brevity:

=VLOOKUP(A1,{"a",5;"b",5;"c",10;"m",15},2,0)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"littlebit" wrote in message
...
I'm tryng to write a statement for the following:
if a or b are typed in cell than 5 is the multiplier, if c is typed in
cell
than 10 is multiplier, if m is typed in cell than 15 is multiplier,
anything
else would give an error code. help appreciated. using excel 2000.