I am running a pref calc on a property with multiple investors and the pref % changes each year. However it is not compounding so no pref is earned on pref from the previous year. How do I stop each formula once 365 days have passed and then begin with the new pref for the next year?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Need Formula to Stop After Certain Date is Reached
- Thread starter chelstru
- Start date
CyrusTheVirus
Well-known Member
- Joined
- Jan 28, 2015
- Messages
- 749
- Office Version
- 365
- Platform
- Windows
Welcome to the forums chelstru,
Could you please post a sample of your data showing what it looks like and also show how you want it to look in the end?
Could you please post a sample of your data showing what it looks like and also show how you want it to look in the end?
Last edited:
Upvote
0
Similar threads
- Question
- Question
