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.