calculating interest
hey
I get 0.99998 using =1303.54*1*2.8%/365
What are you getting and what don't you like about it?
Gord Dibben MS Excel MVP
On Sun, 24 Jun 2007 15:49:00 -0700, leslie
wrote:
hey,
one the numbers are as follows;
1303.54*1*2.8%/365
that is I9*J9*D7/365
it should turn out to be .09
leslie
"FSt1" wrote:
hi,
formating should have nothing to do with it.
since you feel the formula isn't working, what are the numbers and what do
you think the results should be?
"leslie" wrote:
Hi
I suck at this so be patient1
I'm trying to calculate interest using the formula
balance*days-since-last-translation*interest rate/36 I9*J9 *D7/365
I think its not working because d7 is formatted as a percentage (2.8%).
how do I get it to work?
|