Adding percentage as interest to a total

C

Cath

Hello,
I'm hoping someone can help me.
I have a spreadsheet where I keep a tally of money owing to us. We need to
add 8% on the total each time.
So I have the formula for eg. =SUM(C107-B108)
but i need to add 8% onto C108
Can any one help me with this formula
Thanks so much
 
C

Carim

Hi,

To simplify, your formula (I assume in cell C108) should be =C107-B108
Now if the interest 8% is located in A108, your new formula in cell
C108 will become
=(C107-B108)*(1+A108)

HTH
Carim
 
B

Bob Phillips

=(C107-B108)*108%

no need for SUM.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

Cath

Thank you thankyou thankyou, that works perfectly. Hope I can keep it going
all the way down now.
Cheers
Cath
 
Top