conditional formatting
 

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
 

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

conditional formatting
 

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
 

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

conditional formatting
 

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

conditional formatting
 

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

conditional formatting
 

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

conditional formatting
 

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

conditional formatting
 

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

conditional formatting
 

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