IF Formula/Conditional Formula Help

questionking

New Member
Joined
Sep 26, 2017
Messages
17
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.

1577207137004.png
 

Attachments

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

questionking

New Member
Joined
Sep 26, 2017
Messages
17
Thank you, that worked! And now I don't have to use something keying off the RoundDown formula column I created.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,782
Messages
5,446,469
Members
405,403
Latest member
horace james

This Week's Hot Topics

Top