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

  • Thread starter Thread starter trip_to_tokyo
  • Start date Start date
T

trip_to_tokyo

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.
 
Hi Eduado, you have given same response as Sam. Thanks, tested and working
Wed Aug 26/9.
 
Back
Top