Excel Formulae?

  recap 15:11 20 Oct 2006
Locked

Having a problem with working out this formulae. It's most probably a simply one but I don't seem to see the wood for the trees, so to speak.

Cell A1 = £16 then it can be multiplied by any single value (e.g. 5, 6 ot 7)of which are linked to a minus percentage value, then VAT is added. Then an annual increment of 3%. I can do up to the VAT calculation but not the 3% in the same formulae.

An example:
A1 = £16 * 7 - 40% + VAT - 3%

Any help would be appreciated.
recap

  VoG II 15:22 20 Oct 2006

It would help if you could explain a bit more in words what you are trying to achieve. As I interpret it:

1. multiply 16 x 7

2. subtract 40% of that value (or get 60% of that value)

3. Add VAT @ 17.5%

4. Subtract 3% of the value (or return 97% of the value).

If that is the case

=0.97*(1.175*0.6*(16*7))

  recap 15:32 20 Oct 2006

Thanks VoG™

1. multiply 16 x 7

2. subtract 40%

3. Add VAT @ 17.5%

4. Each year an increase of 3% of the total value of step 3 is to be applied

  VoG II 15:39 20 Oct 2006

Step 4 implies that you are generating a series of values. So for example in A1

=1.175*0.6*16*7

then in A2

=A1*1.03

click in A2, hover the cursor over the bottom right of the cell until it turns into a + then hold down the left mouse button and drag down as many rows as needed to cover the range of years.

  recap 15:46 20 Oct 2006

Thanks VoG™, much appreciated.

resolved.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?