Hi
I'm trying to come up with a formula for fee's charged on a quarterly basis.
The fee is £1 per million nominal per quarter (charged at the end of March, June, Sept, Dec).
For example, if I have a nominal of £3,250,000 then I will be charged £1 per quarter.
I also need to reference the date in, so if the £3,000,000 nominal has an effective date of 18th May 2011, I will be charged £9 (£3 in Jun, Sep and Dec)
I'm currently using
=FLOOR(H3530,1000000)/1000000*DAYS360(C3530,(DATE(2011,12,31)))/90
H3530 is the nominal and C3530 is the date but the result I'm getting is 7 rather than 9.
Any help would be great.
Thank you
Any idea's?
Hello
I'm not 100% sure that I've got what you want but for what it's worth would the following formula work?
Sorry if it's rubbish but I had a go.=(4-(CEILING(MONTH(C3530)/3,1))+1)*FLOOR(H3530,1000000)/1000000
DBY
Last edited by DBY; 02-11-2012 at 09:03 AM. Reason: Inserted Code Tags
Think this will do as you need
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks