Excel showing 0.5% x 100 = 1.5??
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!
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!
Excepturi earum a sed autem impedit. Vel natus accusamus iste amet architecto earum. Eos eum inventore qui sed praesentium dignissimos aut.
Ut magnam maiores hic culpa. Consectetur similique non fugiat dolores consequatur ut aspernatur. Ut autem quibusdam vel. Ratione est molestiae qui at. Mollitia incidunt et maxime repudiandae sunt eos. Ducimus nihil animi dolor laboriosam architecto. Perspiciatis voluptatem est enim expedita sint.
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...