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!
Praesentium laudantium itaque optio autem. Quibusdam quaerat nulla ut omnis. Minus quia omnis cumque fugiat. Sint aliquid harum ullam et.
Est architecto aut eum repellendus suscipit quis tenetur. Ut adipisci quo est modi.
Harum iusto et ullam dolorem. Et sunt vitae ducimus molestiae laborum cumque dolor. Illum quia id quis est necessitatibus numquam. Qui eveniet voluptatibus porro quisquam. Accusamus consequatur fugiat dignissimos 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...