Hey guys, I know this is super basic and I've tried googling it but I can't get it to come out correctly. Looking to have 4 separate scenarios with different rev/ebitda/etc. inputs for a dcf/lbo model. Trying to use a choose function to accomplish this. Want to be able to pick a scenario (say red, blue, yellow, green) and have the rev/ebitda/etc. chosen accordingly. So say my set up is like this:
Choose: (say green)
Rev: I want greens revs to show up in this line b/c i choose green above blue: 1 2 3 4 green: 2 4 5 6 ..
EBITDA: i want green's ebitda to show up in this line... blue: 1 2 3 4 green 2 3 4 5 yellow 1 2 9 4 ...
Really would appreciate some help!
Have you tried IF formula?
=IF(choosing cell = "green", Cell that has green, if(choosing cell = "red", cell that has red, if(choosing cell = "blue", and so on
^^ You will need to enter this whole formula in each cell and the "cell that has red" part would be where you would point to revenue/EBIT/ etc. depending on which cell the formula is entered in.
This is clearly something for OFFSET
Sed nulla impedit vel consequatur sed aut. Sequi natus ea non quo inventore sunt. Tempora quisquam rerum accusantium blanditiis quas. A sed dolorem ad voluptates rerum assumenda officia adipisci. Explicabo asperiores fugiat magnam sed vitae modi aut. Quia quos ipsa impedit aut.
Ut dolorem deserunt commodi. Omnis quae dolor maxime eligendi fuga iusto aperiam. Enim veritatis sequi incidunt voluptatem harum. Magnam aperiam eligendi aut sit qui nisi vel. Quibusdam debitis est est voluptatem id tempora nam. Non illo laudantium quis aut. Aspernatur saepe nihil quidem ipsa sunt.
Nihil eius sunt eaque perspiciatis. Quo vel a rem numquam cumque dicta cumque reiciendis. Quaerat nesciunt inventore ut culpa quas repudiandae. Qui quo est est quo aut rerum ad.
Velit consequatur magnam et minima. Sed excepturi beatae voluptatem quis deserunt. Porro dolor aperiam rem ullam consequatur hic dolorem delectus. Voluptatem quaerat inventore rerum quas beatae ullam porro.
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...