I have attached a sample file.
I am making a business case template for my work.
I have a simple row with costs per time period (e.g. months) and a simple row with savings per time period.
I have hidden rows with accumulated costs and savings.
In row 27 there is a simple IF formula comparing accumulated costs and savings. If savings are greater than costs for that period there is break-even. However, the subsequent period is also break-even (which is technically not true).
So, is there a way to only show the words "break-even" once?
Alternatively, can I write a formula that would just tell me in which period the accumulated savings exceed the costs? E.g. month 7.
Bookmarks