Do you guys know of a simple way to model events happening at a given moment in time - eg a specific month - without a complicated if/then formula? Let’s take real estate model for an example. Let’s say we have some revenue or cost event happening in Month 6. But we want month 6 to be an assumption and it could be changed to Month8 or Month10 in the assumptions box. Now I know I can put in a formula or an array that says “if current_month is >M6 then … “ but those make the model illegible for anyone but the author. Is there a simpler and more elegant solution?
Trending Content - Off Topic Forum
| +62 | BofA VP killed in random NYC stabbing | 37 | 1h |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 3d |
| +17 | Western Investment Bankers Deserve No-Minimum-Wage Nannies, and I Want Mine NOW | 6 | 15h |
| +16 | evercore isnt opening today | 12 | 49m |
| +15 | Lindsay Clansey | 6 | 1d |
| +15 | Deleted | 6 | 2h |
| +13 | At what salary can you start calling it “fi-NANCE” | 4 | 23h |
| +10 | Hair Transplant | 3 | 1h |
| +9 | NYC apartment hunting rant: everyone and their mother and brother are touring | 1 | 11h |
| 0 | Abstention | 1 | 1d |
Career Resources
I’m not sure exactly what you’re trying to do but some form of modulus is likely to help you make assumptions in a series - MOD() in excel.
Flags are your friend. Have a flag that toggles every x months (can use mod() per the above comment) and then link your actual calc to the flag. Makes it 1000x more legibile and easy to understand.
Generally I've found having helper calculations, such as time series flags or intermediate outputs, is a lot better than trying to jam a multi-step formula into one cell.
Just do a true false - =((current_month)=(input)) * output
Thanks. Can you explain this a bit further? Like if I have my time series Month1-M12
I have a line item that I want triggered but I'd like to toggle when it begins. eg. M 3 or M4, TBD by user.
I can have an assumption tab that has states when the line item begins. But then I get confused. I believe I can do something where there's a row for the month number and then compare than with a >= to the assumptions month, and if so, then put in LineItem. But this syntax is long and confusing. There should be a simpler way.
I don't think I really follow your meaning by
And I also don't understand what randwithabando meant by =mod()
Mod(x,y) returns: the remainder of x/y if x>y, 0 if x=y, x if x
Eum impedit quaerat consequuntur aut fugiat veniam. Vel hic iste quia fugiat a quia.
Enim tempora voluptatem non qui. Iste occaecati praesentium aliquam. Et excepturi fuga voluptatem vel error autem dolorem.
Id deleniti molestiae ipsum quidem laboriosam. Temporibus deleniti cumque aliquid sed alias molestias inventore. Et ut ducimus eum nisi ipsum ut placeat nihil. Eveniet est saepe nihil et accusamus recusandae non. Minima et nulla enim explicabo aut non. Sed qui necessitatibus velit et sit voluptas. Debitis molestiae at neque repellendus vero quasi.
A quidem nobis laboriosam ut odit. Perspiciatis deleniti repudiandae et fugiat.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...