Draw Rules

**MAHMUZ** · 04-25-2010, 04:59 AM

Dears;

I need some help to write the formula in the attached file.

BR

**DonkeyOte** · 04-25-2010, 05:17 AM

It would be an idea to outline expected results - and also provide a few more examples that illustrate the 120, 180 concept ... ie what happens for a $50 deposit of 180 days - is that 1 chance of 3 chances ?

As a starting point perhaps

F3: =INT(IF(E3<7;C3>=50;(C3/50)*1+MAX(0;(FLOOR(E3;60)-60)/60)))
copied down

**MAHMUZ** · 04-25-2010, 08:58 AM

Originally Posted by DonkeyOte

It would be an idea to outline expected results - and also provide a few more examples that illustrate the 120, 180 concept ... ie what happens for a $50 deposit of 180 days - is that 1 chance of 3 chances ?

As a starting point perhaps

F3: =INT(IF(E3<7;C3>=50;(C3/50)*1+MAX(0;(FLOOR(E3;60)-60)/60)))
copied down

Thanks for your kind reply, after I copied the above formula the result is invalid, please take your time to review it in the attached file and advice.
sorry for any inconvenience.

Iam using excel 2007.
BR

**DonkeyOte** · 04-25-2010, 01:00 PM

There is a typo in the formula - the 1+MAX(...) should be encased within parentheses - ie (1+MAX(...)) ... also I used C3 as the amount rather than D3 - alter as necessary.

Draw Rules

LinkBack

Thread Tools

Rate This Thread

Display

Draw Rules

Re: Draw Rules

Re: Draw Rules

Re: Draw Rules

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions