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.
|