Not sure if I accidently changed some settings or it's my computer but here's the issue:
When I drag a formula down, it isn't using the new cells in the formula that should have inherently been dragged down as well. It drags the right formula, but the value that shows up is the same as the original value from the original cell. If I hit F9 and refresh, the value changes to what it should be.
| +183 | Return Rates For Interns Are Falling? | 77 | 10m |
| +128 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 20h |
| +99 | I am a drunk MD AMA | 37 | 3h |
| +76 | London IB BB is a challenge | 41 | 16h |
| +63 | VP Lifestyle at Top BB Coverage Groups | 40 | 5h |
| +63 | KISSED MY VP… HELP!!! | 15 | 2h |
| +57 | An Outsider’s View of RX Banking Out of College | 7 | 6h |
| +49 | SharePoint makes IB hours HELL | 15 | 2d |
| +46 | UBS Offer Day | 18 | 4h |
| +43 | momentum of Rx groups | 16 | 10h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
You might be using excel in Manual calc mode. Change that to automatic and it should be fine
To change that, you just need to go to the Formulas ribbon (for excel 2007 or higher) and find the button where it says "calculation mode" at the right. click on the arrow to see the options and select Automatic.
Much appreciated.
Quia magnam autem voluptatem nostrum alias a quia. Provident quaerat ut et modi aut. Adipisci voluptatem est maxime quo est quia recusandae. Cum reiciendis vel facere aliquid similique laboriosam.
Ratione consectetur sit nihil vel velit molestiae. Reprehenderit quia veritatis labore quos iusto suscipit placeat. Pariatur voluptas accusamus qui doloremque nihil. Impedit atque quisquam odit aliquam.
Molestiae dicta provident accusamus accusamus beatae repellendus pariatur. Rerum nam reiciendis aut dignissimos quo ipsam. Ea omnis cupiditate ut nostrum. Nisi enim ullam tenetur. In inventore atque sed cumque ut.
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...