Adding percentage as interest to a total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cath - 15 Apr 2006 12:35 GMT

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

Reply to this Message

Carim - 15 Apr 2006 12:48 GMT

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

Reply to this Message

Bob Phillips - 15 Apr 2006 12:50 GMT

=(C107-B108)*108%

no need for SUM.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hello,
> I'm hoping someone can help me.
[quoted text clipped - 4 lines]
> Can any one help me with this formula
> Thanks so much

Reply to this Message

Cath - 15 Apr 2006 13:03 GMT

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

> =(C107-B108)*108%
>
[quoted text clipped - 8 lines]
> > Can any one help me with this formula
> > Thanks so much

Reply to this Message