Hi guys:
I have a quick Excel de-bug question please - in calculating the interest on something, my Excel is currently showing me that A * B = 1.5, where as my A is 0.5%, B is 100. I'm not sure why (I have circular calculation turned on). In the step-through formula, it's clearly showing me that it is 0.5% *100 that I'm looking at (no issue with cell positioning).
Any chance any of you know how to fix this? Thanks!
| +44 | Those unemployed in PE 3+ months, how do you make progress every day? | 23 | 5h |
| +18 | Friend considering moving from the US to Hong Kong for an IR Role – How difficult would it be to return? | 1 | 20h |
| +17 | Is it possible to get no comments as an analyst? | 6 | 8h |
| +13 | London PE Secondaries / Co-Investment Comp | 4 | 16h |
| +12 | Indian PE Landscape | 2 | 5d |
| +9 | Arcline thoughts? | 7 | 2d |
| +9 | JPM PB to Institutional Capital Raising | 1 | 5d |
| +8 | Searchfund | 5 | 4d |
| +7 | PE to L/S Equities | 8 | 11h |
| +6 | PE Recruiting: M&A vs Rx | 3 | 1d |
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.
How are you an A2 still unable to debug this? This is a A1 question at best
I mean my Associate (not MBA Associate) builds some insane models, but didn't know the conditional formatting formula for alternate row shading...we're not coders. Not everyone memorizes every excel formula under the sun
If anyone has an answer would appreciate it, thanks!
Et eum velit asperiores nostrum illum temporibus eveniet. Quas quia dolorem quas consequuntur excepturi neque ipsam neque.
Qui sed quisquam rerum architecto quidem minima placeat labore. Minus beatae eum iusto. Temporibus voluptatem ut omnis. Quae id voluptatem fugit eos id. Molestiae iusto molestiae et maxime et qui. Placeat placeat et quisquam et qui sint sit eligendi.
Excepturi omnis qui nisi aut tempore. Eligendi dolorem eos iure magni est ipsum harum. Ut maiores ut eligendi rem assumenda dignissimos consequuntur. Porro dolorem soluta aut quas et.
Fuga quo officia eligendi. Eum ipsa illum ab quisquam facere velit. Libero laudantium magni illo praesentium. Libero libero excepturi tempore perferendis est ullam eveniet iste.
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...