Adding percentage as interest to a total
 

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

Adding percentage as interest to a total
 

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

Adding percentage as interest to a total
 

=(C107-B108)*108%

no need for SUM.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Cath" wrote in message
...
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

Adding percentage as interest to a total
 

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

"Bob Phillips" wrote:

=(C107-B108)*108%

no need for SUM.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Cath" wrote in message
...
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