Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle

a formula
=LOOKUP(B1,{"a","b","c","d"},{4,3,2,1})*B4
--
Don Guillett
SalesAid Software

"MichelleD" wrote in message
...
Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle

What does your question have to do with the subject line: conditional
formatting?

Try this:

=IF(OR(B1={"A","B","C","D"}),B4*MATCH(B1,{"D","C", "B","A"},0),"")

Biff
Microsoft Excel MVP

"MichelleD" wrote in message
...
Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle

Conditional formatting does not change the underlying value. If you want the
result in some other cell than those you listed, you could use a nested IF,
like
=IF(B1="D",B4*1,IF(B1="C",B4*2,IF(B1="B",B4*3,IF(B 1="A",B4*4))))
For a larger list, you might prefer to use a VLOOKUP() table.

Note that you have not specified an action if none of the conditions are true.

Jerry

"MichelleD" wrote:

Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle

Hope this helps!

=IF(B1="D",B4*1,IF(B1="C",B4*2,IF(B1="B",B4*3,IF(B 1="A",B4*4,0))))

"MichelleD" wrote:

Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle

T. Valko, that was genius!

"T. Valko" wrote:

What does your question have to do with the subject line: conditional
formatting?

Try this:

=IF(OR(B1={"A","B","C","D"}),B4*MATCH(B1,{"D","C", "B","A"},0),"")

Biff
Microsoft Excel MVP

"MichelleD" wrote in message
...
Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle

I appologize for my misuse of terminology. I'm obviously not an excell
expert....

Your help is appreciated.

"T. Valko" wrote:

What does your question have to do with the subject line: conditional
formatting?

Try this:

=IF(OR(B1={"A","B","C","D"}),B4*MATCH(B1,{"D","C", "B","A"},0),"")

Biff
Microsoft Excel MVP

"MichelleD" wrote in message
...
Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle

Thanks for everyone's help! I really appreciate it!

Michelle

and to the poster (Jerry) that asked about when none of the conditions are
true..in this case it woulsd always be a, b, c or d.

Thanks again!

"MichelleD" wrote:

Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle

to compensate for higher than D
=LOOKUP(B5,{"a","b","c","d","e"},{4,3,2,1,0})*B4

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
a formula
=LOOKUP(B1,{"a","b","c","d"},{4,3,2,1})*B4
--
Don Guillett
SalesAid Software

"MichelleD" wrote in message
...
Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle

Try this:

=(69-CODE(UPPER(B1)))*B4


"MichelleD" wrote:

Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle