=+AMOUNT*rate%/365*(DATE(YEAR(YEAREND),MONTH(MATURE),DAY(MATURE))-DATE(YEAR(YEAREND),MONTH(1),DAY(1)))+((((AMOUNT+(AMOUNT*rate%))*rate%)/365)*(YEAREND-(DATE(YEAR(YEAREND),MONTH(MATURE),DAY(MATURE)))))
is just a part of the formulas i have to use!
yes i am definitely not an expert!
anyway... is there some way of avoiding this?
like just have a formula that says if this then go to say C1 where the needed formula is.
the above works out the interest up to the compounding date and the interest hafter that date. for one year.
thanks all
is just a part of the formulas i have to use!
yes i am definitely not an expert!
anyway... is there some way of avoiding this?
like just have a formula that says if this then go to say C1 where the needed formula is.
the above works out the interest up to the compounding date and the interest hafter that date. for one year.
thanks all