1. ## Percentage calculation (XP)

I have to calculate a percentage.
Mr X gives company money, takes it out after several days/weeks with interest.
I now have to calculate the interest amount, the interest percentage and the interest he received per day.
I have attached a spreadsheet and like to know if I'm on the right track.
Not sure if I calculated the interest per day correctly.

2. ## Re: Percentage calculation (XP)

I calculate the interest/ day for row 11 as:
=(EXP(LN(D11/B11)/E11)-1)

= 6.5%/day

Steve

3. ## Re: Percentage calculation (XP)

Or
<code>
=(D11/B11)^(1/E11)-1
</code>

4. ## Re: Percentage calculation (XP)

Thanks for that. I would have never known that

Thanks again

5. ## Re: Percentage calculation (XP)

<img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> I thought it could be simplified.

<img src=/S/blush.gif border=0 alt=blush width=15 height=15>I guess that will teach me not to post right before I pack up to go home and don't make time to simplify...

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•