If C2 = East AND D2 < 20,000.00 then multiply D2 by 8%
 

1. In cell C2 I have a region called East (other regions called North, South
and West).

In cell D2 I have a revenue of 10,000.00.

In F2 I want to enter a formula that does the following:-

If C2 = East

AND

D2 < 20,000.00

then take the value in D2 (currently 10,000.00) and multiply it by 8%
(placing the result in F2).

2. BOTH conditions must be TRUE if the value in D2 is to be multiplied by 8%.

3. Which formula do I need to enter in cell F2 to achieve the above?

4. Can I set the above up by using Formulas?

Many thanks in advance for any help.

If C2 = East AND D2 < 20,000.00 then multiply D2 by 8%
 

Put this in F2:

=IF(AND(C2="East",D2<20000),D2*0.08,"")

"trip_to_tokyo" wrote:

1. In cell C2 I have a region called East (other regions called North, South
and West).

In cell D2 I have a revenue of 10,000.00.

In F2 I want to enter a formula that does the following:-

If C2 = East

AND

D2 < 20,000.00

then take the value in D2 (currently 10,000.00) and multiply it by 8%
(placing the result in F2).

2. BOTH conditions must be TRUE if the value in D2 is to be multiplied by 8%.

3. Which formula do I need to enter in cell F2 to achieve the above?

4. Can I set the above up by using Formulas?

Many thanks in advance for any help.

If C2 = East AND D2 < 20,000.00 then multiply D2 by 8%
 

Hi,

in F2 enter

=IF(AND(C2="East",D2<20000),D2*0.08,"")

"trip_to_tokyo" wrote:

1. In cell C2 I have a region called East (other regions called North, South
and West).

In cell D2 I have a revenue of 10,000.00.

In F2 I want to enter a formula that does the following:-

If C2 = East

AND

D2 < 20,000.00

then take the value in D2 (currently 10,000.00) and multiply it by 8%
(placing the result in F2).

2. BOTH conditions must be TRUE if the value in D2 is to be multiplied by 8%.

3. Which formula do I need to enter in cell F2 to achieve the above?

4. Can I set the above up by using Formulas?

Many thanks in advance for any help.

If C2 = East AND D2 < 20,000.00 then multiply D2 by 8%
 

Hi Sam, tested and working Wed Aug 26/9. Look spot on to me. Thanks!

"Sam Wilson" wrote:

Put this in F2:

=IF(AND(C2="East",D2<20000),D2*0.08,"")

"trip_to_tokyo" wrote:

1. In cell C2 I have a region called East (other regions called North, South
and West).

In cell D2 I have a revenue of 10,000.00.

In F2 I want to enter a formula that does the following:-

If C2 = East

AND

D2 < 20,000.00

then take the value in D2 (currently 10,000.00) and multiply it by 8%
(placing the result in F2).

2. BOTH conditions must be TRUE if the value in D2 is to be multiplied by 8%.

3. Which formula do I need to enter in cell F2 to achieve the above?

4. Can I set the above up by using Formulas?

Many thanks in advance for any help.

If C2 = East AND D2 < 20,000.00 then multiply D2 by 8%
 

Hi Eduado, you have given same response as Sam. Thanks, tested and working
Wed Aug 26/9.

"Eduardo" wrote:

Hi,

in F2 enter

=IF(AND(C2="East",D2<20000),D2*0.08,"")

"trip_to_tokyo" wrote:

1. In cell C2 I have a region called East (other regions called North, South
and West).

In cell D2 I have a revenue of 10,000.00.

In F2 I want to enter a formula that does the following:-

If C2 = East

AND

D2 < 20,000.00

then take the value in D2 (currently 10,000.00) and multiply it by 8%
(placing the result in F2).

2. BOTH conditions must be TRUE if the value in D2 is to be multiplied by 8%.

3. Which formula do I need to enter in cell F2 to achieve the above?

4. Can I set the above up by using Formulas?

Many thanks in advance for any help.