Using IF to deduct from cumulative totals

Hello everyone,
I have a spreadsheet that every 2 weeks adds money to a total (E7). At the end of the month according to how much money you have; you can buy 1, 2, 3… bonds (C7). I want a formula that according to how much we have will come up with the number of bonds to buy. It will never be more than 3 bonds per month. The formula that I try to use was
=IF(E10>=50,1, IF(E10>=100,2,"")) but didn’t work for more that 1 bond. Any suggestion I will really appreciated!!

=IF(E10>=50,1, IF(E10>=100,2,""))

Will always stop after any value equal or gretar to 50

try

Please Login or Register  to view this content.

Thank you very much Arthur,
This seems to work and i can do modifications. I am at work right now so i have to go in & out of the board. THANKS!!