Draw Rules

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