Formula Help
 

I need to write a formula in excel that says the following:
If C2 = "x" and B2 = "d", then D2*21%

I can get the first part using the IF function, but I am only allowed 1
logical test - how can I use 2?

Thanks!!!!

Formula Help
 

Amy,

Try this

=IF(AND(C2="x",B2="d"),D2*21%,"")

Mike

"Amy" wrote:

I need to write a formula in excel that says the following:
If C2 = "x" and B2 = "d", then D2*21%

I can get the first part using the IF function, but I am only allowed 1
logical test - how can I use 2?

Thanks!!!!

Formula Help
 

Anyway for me to take it further and say
=IF(AND(C2="x",B2="d"),D2*21%,"") or if B2="e",D2*14%



"Mike H" wrote:

Amy,

Try this

=IF(AND(C2="x",B2="d"),D2*21%,"")

Mike

"Amy" wrote:

I need to write a formula in excel that says the following:
If C2 = "x" and B2 = "d", then D2*21%

I can get the first part using the IF function, but I am only allowed 1
logical test - how can I use 2?

Thanks!!!!

Formula Help
 

=IF(AND(C2="x",B2="d"),D2*21%,IF(B2="e",D2*14%,"wh atever you want in the
other cases"))
--
David Biddulph

"Amy" wrote in message
...
Anyway for me to take it further and say
=IF(AND(C2="x",B2="d"),D2*21%,"") or if B2="e",D2*14%



"Mike H" wrote:

Amy,

Try this

=IF(AND(C2="x",B2="d"),D2*21%,"")

Mike

"Amy" wrote:

I need to write a formula in excel that says the following:
If C2 = "x" and B2 = "d", then D2*21%

I can get the first part using the IF function, but I am only allowed 1
logical test - how can I use 2?

Thanks!!!!