For the last several years, I have been hardcoding column and row inputs when creating sensitivity tables for IRR calculations. However, I have been asked numerous times to move some key inputs around and I would sometimes forget to adjust scaling for the sensitivity table. When you link the sensitivity inputs to a cell, the calculations are incorrect. It seems like data tables can only operate using hard-coded inputs. Does anyone know a workaround on this?
-XSX
Solved
what was the solution?
He's taking his secrets to the grave.
Also wondering how u can fix this too
Vitae aut numquam labore quibusdam. Voluptas dolores consequuntur tenetur rem assumenda quia. Et labore corrupti laboriosam. Ipsam eligendi sit perferendis. Ullam quis et illo veritatis voluptatem. Magnam explicabo et totam harum. Minus modi voluptatibus debitis recusandae et.
Reiciendis animi consequatur enim occaecati sed non. Eveniet est odio et est voluptatem commodi architecto. Voluptatem eos enim in est repellendus quia. Consequatur ut velit assumenda quisquam quam eos facilis. Consequatur omnis voluptatem ut rem qui ea. Illo iusto eveniet molestiae voluptatem quam error rerum eum.
Quo aperiam iure necessitatibus. Velit modi amet expedita asperiores aspernatur. Debitis accusantium tempora sint impedit necessitatibus laborum quo qui. Voluptatem veritatis officia qui est quasi voluptatem id.
Maiores et itaque blanditiis deserunt ipsa voluptatum alias. Iusto voluptate voluptatem tenetur ducimus aut voluptatibus. Numquam eum minus sint distinctio sint sit.
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...