New Formulae

  • Thread starter Thread starter David Harrison
  • Start date Start date
D

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
 
It might be helpful to for you to specify what you'd expect to see as
results in A3:F3 of your example.
 
Back
Top