IF Formula/Conditional Formula Help

[questionking]

I am attempting a simple reinvestment strategy. In the scenario shown below every year in which the store hits $5,000 in Running Sales, an investment of $5,000 is made to open a new store. So in theory, a year in which $10,000 in Running Sales was generated 2 new stores would open. However, a year in which $7,500 in Running Sales was generated only 1 new store would open not 1.5 new stores.

The two highlighted cells need to be 1.00. Any help or suggestions would be greatly appreciated. Thanks.

 

[Scott Huish]

=IF(D9<5000,"-",INT(D9/5000))

 

[questionking]

Thank you, that worked! And now I don't have to use something keying off the RoundDown formula column I created.