New Formulae

[David Harrison]

Could some one please tell me how to work out this
formulae.

I have columns set up in months.

A B C D E F
JAN FEB MAR APR MAY JUN 1
100 200 300 300 400 500 2
? ? ? ? ? ? 3

What i need to do is take 80% of the value in A2 and put
80% of the original 80% in cell D3. I then need to put
the remainder of the second 80% being 20% in E3. However,
E3 must also have 80% of 80% from B2.

If you dont understand then i dont blame you becasuse i
have confused myself. If you do then great.

Many Thanks

David Harrison

 

[JE McGimpsey]

It might be helpful to for you to specify what you'd expect to see as
results in A3:F3 of your example.