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!
| +106 | Is Everyone Too Bearish on PE? | 34 | 1d |
| +48 | Why would anyone do PE in long term in 2026? | 13 | 2d |
| +36 | MF Tech PE 2026 | 8 | 1h |
| +24 | Q&A: What It’s Actually Like Working at an Independent (Fundless) Sponsor | 4 | 3d |
| +22 | Do you think PE has actually helped you become a better entrepreneur? | 8 | 21h |
| +21 | UMM PE or High Paying Strat Finance? | 13 | 1d |
| +21 | Striking out in last rounds | 2 | 5d |
| +16 | Portfolio Marks | 8 | 18h |
| +15 | Overwhelmed by amount of data / granularity | 3 | 2d |
| +15 | DELETE | 1 | 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.
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!
Qui aspernatur accusantium nobis nesciunt sint voluptatem incidunt. Ut voluptatem sit eaque. Id qui vel fuga et deserunt molestiae.
Similique et sint ut repellendus corrupti. Necessitatibus commodi aliquam accusamus rerum delectus veritatis.
Rerum nostrum qui optio non. Molestiae est nam est ratione voluptatibus sit aperiam. Occaecati vel dolores nam. Ipsa eos minima enim officia enim. Adipisci aut enim porro consectetur provident vel qui.
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...