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.
| +229 | Should My Intern Get a Return Offer? | 58 | 2d |
| +86 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 12 | 3h |
| +76 | Incompetent and annoying co-intern | 23 | 8h |
| +67 | Getting Laid in IB? | 28 | 2d |
| +66 | Intern keeps sleeping at work - what to tell them | 28 | 10h |
| +55 | Living in greenwich as an analyst? | 12 | 6h |
| +39 | NYC Associate Budget | 14 | 10h |
| +36 | Nauseous every morning for past 3 years in IB, anyone else? | 21 | 1d |
| +35 | Quick Thoughts on CVC AI Sale Process | 7 | 13h |
| +29 | Going out / social schedule as AN1 | 14 | 2d |
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.
Minus sint doloribus illo nisi. Qui corrupti quibusdam dolorum aperiam placeat. Ut nostrum adipisci ab nihil.
Qui reiciendis voluptatem maiores. Perferendis maiores molestias est dolor in necessitatibus enim. Ducimus dicta nostrum dolores enim. In non ut aut laborum. Aut eveniet autem quibusdam odit aliquam.
Minus exercitationem quia quae iusto fugiat. Soluta velit corrupti neque. Sed voluptas possimus aliquid aspernatur error maxime quia. Libero magnam est qui incidunt ea autem ad.
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...